Property Master Upload Template

Purchaser Property Master records can now be uploaded from a template using the Upload Purchaser Property Master - REV101 screen. The .txt tab delimited file must comply with the following order and column designations in order for the import upload to be successful. The delimited files are not required to comply with the specific column width designations but must comply with the column order of the data.

EXCEL COLUMN	COLUMN IN REV1 REPORT	ATTRIBUTE	REQUIRED	MUST ALREADY EXIST

EXCEL COLUMN	COLUMN IN REV1 REPORT	ATTRIBUTE	REQUIRED	MUST ALREADY EXIST
A	1	Company	Y	Y
B	2	Purchaser	Y	Y
C	3	Property	Y	Y
D	4	Well	Y	Y
E	5	Product	Y	Y
F	6	Check Stub	N	Y
G	7	Validation	N	Y
H	8	Cash Basis	Y	N
I	9	Rollup Property	N	Y
J	10	Barrels/Gallons	N	N
K	11	Inflation Factor	N	N
L	12	Stripper	N	N
M	13	Expire Date	N	N
N	14	Suppress Posting	N	N
O	15	Tax District	N	Y
P	16	Analyst	N	Y
Q	17	Deduct Comp	N	Y
R	18	Remit Comp	N	y

Notes:

Company: Required (COM168)
Purchaser Id: Required (CUS500)
Property: Required (from Purchaser or Remitter - do not exceed 12 char)
Well: Required (REV120)
Product Code: Required (REV151)
Check Stub Master: Optional
Validation: Optional, valid codes are 1-7, Default code is "4"
Cash Basis Property: Required (Default is "N"o)
Rollup Property: Optional (Must exist in REV120 if also used in Purchaser Property Master Upload)
Barrels and Gallons (B/G): Optional (Required if conversion is needed)

B: Divide by 42 (Volumes received are gallons and converted to barrels.)

G: Multiply by 42 (Volumes received are barrels and converted to gallons.)

Blank /null/ if volumes received are in reporting basis of gallons or barrels

Inflation Factor: Optional (Required if detail from remittance is by Tract. Enter Tract Participation Factor as Inflation Factor in this attribute)
Str: Optional (Yes or No - Evaluate requirements for Colorado Stripper Wells)
Expiration Date: Optional (Only needed when Purchaser Property Master is no longer required. Original Purchaser Property Master is valid for processing any date prior to expiration date
Suppress Posting: (Optional - Yes or No - Default is "N"o) Enter "Y"es if 8/8ths for a specific Purchaser Working Interest should NOT be posted for disbursement transaction
Tax District: Optional (Enter value from Tax District code file – REV126 - when component calculations require a well specific rate)
Analyst: Optional (Must be a valid code – REV136)
Deduct Component: Optional (Component Code must exist – REV125 - before referencing on Purchaser Property Master Upload. User can add any number of Deduction Components with each separated by a comma.
Revenue Component: Optional (Revenue Component Code must exist – REV125 - before referencing on Purchaser Property Master Upload. User can add any number of Revenue Components with each separated by a comma.)