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. |