Journal Entry Line Item Tables
Journal Entry Line Item Tables
Definition
PRA contains a General Ledger and ten line item tables. A line item table is a table containing journal entries specific to a particular function. The PRA JE posting process (see:
The JE Posting Process) posts to ten separate line item tables. The determination in the system of which journal entries will be posted to which line item table is made based on the account type assigned to the journal entry.
It is important to note that every posting in JE always has two accounts that are posted to:
The account type determines which JE line item table the journal entry will be posted to.
JE has the following line item tables (the technical name of the table is provided here if you want to view the table itself):
|
Line item table name |
Line item table description |
|
Miscellaneous (Table OIUH_RV_MSSL) |
Used by various RD reporting processes |
|
Inter-company (Table OIUH_RV_ICSL) |
Used for accounting between companies. Used in automatic billing situations (as opposed to situations in which a check is sent). Used when an affiliate is an owner in a DOI to which the processing company is distributing revenue. The affiliate’s share of sales, tax expense, marketing expense, etc. is recorded in separate accounts on the affiliate’s ledgers, and a payable entry for the net amount is recorded to an account in the Inter-Company Payable category on the processing company’s ledgers. The entry represents money that must be distributed to the affiliated owner by the processing company. |
|
Owner payable (Table OIUH_RV_OPSL) |
Used for RD check-write, royalty reporting, RD reporting, Check Input, Negative invoicing, RD transfer of suspense balances, and Tax and Regulatory Reporting. |
|
Legal suspense (Table OIUH_RV_LSSL) |
Used for RD reporting and the RD transfer of suspense balances. Legal suspense is used when recording net payable amounts to non-affiliated owners who are in legal suspense. |
|
Statistical (Table OIUH_RV_STSL) |
Used for statistical purposes only. Most commonly used to record amounts that would have been paid to carried owners, or to the Minerals Management Service (MMS), when there is a ‘take-in-kind’ situation. |
|
Income (Table OIUH_RV_INSL) |
Used by the RD accrual process, used for the Income Analysis Report, the Sales/Accrual Report, and the Sales History. Income is an affiliated owner‘s share of sales, plus tax reimbursements; it is recorded to accounts in the income category. The share of revenue distribution to an affiliated owner in the DOI. The net amount is recorded on the processing company on the affiliated owner’s behalf. |
|
Expense (Table OIUH_RV_EXSL) |
Records an affiliated owner’s share of marketing costs or tax. |
|
Tax payable (OIUH_RV_TPSL) |
Actual tax amounts that have been calculated in the Valuation module of PRA. It represents the amount payable to state or local taxing authorities. Used for RD reporting and taxes payable write-off processing. |
|
Accounts Receivable (Table OIUH_RV_ARSL) |
Amount to be received from the purchaser in connection with a sale when the purchaser on the contract is non-affiliated. |
|
Accounts Payable (Table OIUH_RV_APSL) |
External marketing charges when the service is not provided by the purchaser or an affiliated company. |
The JE line item table is sometimes represented by the concept of "account ID" in some JE transactions. For example, in the manual journal entry transaction, the account ID refers to the JE line item table that you are posting to.