Upload Formats

Tax Form: O3 file upload format.

Field #	Name	Start	End	Length	Type	Description
1	Product Code (17)	1	2	2	Numeric	Product Code
2	Tax ID	3	12	10	Numeric	Ten digit Louisiana Tax Number.
3	Severance Account Number	13	18	6	AlphaNumeric	Producer or transporter code (up to 6 digits) assigned by Conservation or reporting co. # assigned by LDR. For 4 and 5-digit codes, pad with a leading
4	Tax Period	19	22	4	Numeric	Period for which tax is reduced.
5	Certification Code	23	23	1	AlphaNumeric	Code assigned by the Department of Revenue.
6	Conservation Well Serial Number	24	29	6	Numeric	A code assigned by Louisiana Office of Conservation that may be up to six digits. Number can be less than 6 digits.
7	Continuity Status Code	30	30	1	AlphaNumeric	Status is continuing, new this month, or deleted.
8	Parish Code	31	32	2	Numeric	Parish where production occured.
9	Field	33	36	4	Numeric	Four digit code assigned by Louisiana Office of Conservation.
10	Producer Code	37	42	6	AlphaNumeric	Producer code assigned by Louisiana Office of Conservation that may be up to six digits. For 4 and 5-digit codes, pad with a leading zero(s).
11	Lease Code	43	48	6	Numeric	Six digit code assigned by Louisiana Office of Conservation. Number must be 6 digits.
12	Well Number	49	55	7	AlphaNumeric	A number assigned by Louisiana Office of Conservation to a specfic well for identification purposes (may be up to seven digits).
13	Production Barrels	56	65	10	Decimal(9,2)	Total gross barrels produced or severed during the taxable period.
14	Number of Prod. Days	66	67	2	Numeric	Number of days the well produced during this taxable period.
15	Avg Daily Prod	68	75	8	Decimal(7,2)	Production divided by the number of producing days. Round off two places.
16	Disposition Barrels	76	87	12	Decimal(11,2)	Total taxable barrels for the taxable period for which codes on the line item are applicable.
17	Taxpayer Code	88	93	6	AlphaNumeric	Producer or transporter code (up to 6 digits) assigned by Conservation or reporting co. # assigned by LDR. For 4 and 5-digit codes, pad with leading

Record Length: 93

Note:
Decimals should be given an explicit decimal point. Example: Decimal(12,2) = xxxxxxxxxx.xx which is 13 places.
There should always be two numbers to the right of the decimal. Use zeros if necessary.
Pad numeric types with leading spaces.
Place negative sign before first signicant digit of numeric types.
COMMA DELIMITED: Follow same order as fixed-length file. Place comma between fields.