Billing Load AR Pending Items Process

The Load AR Pending Items process transfers data from the Billing tables to the following Receivables interface tables:

Field or Control Description

GROUP_CONTROL (GROUP_BU, GROUP_ID)

Contains one record for every group of pending items generated through the Load AR Pending Items (load accounts receivable pending items) process.

PENDING_ITEM_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM)

Parent table that contains one record for every pending item generated through the Load AR Pending Items process.

PENDING_DST_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, DST_SEQ_NUM, LEDGER_GROUP, LEDGER):

Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process.

PENDING_VAT_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, VAT_APPLICABILITY, VAT_TXN_TYPE_CD, TAX_CD_VAT, VAT_DST_ACCT_TYPE, VAT_SEQ_NUM):

Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process.

PENDING_TAX_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, TAX_RATE_SEQ

Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process.

PENDING_TAX_DTL_FS (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, TAX_RATE_SEQ, EXS_TAX_RATE_CD, EXS_TAX_RATE_SEQ):

Child table that may contain none, one, or more than one record for each pending item generated through the Load AR Pending Items process.