AR_DEPOSIT_EC(SQL Table) |
Index Back |
|---|---|
AR Payload Deposit Staging |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LB_BANK_TRANS_ID | Character(20) | VARCHAR2(20) NOT NULL | Bank Transmission ID |
| 2 | LOCKBOX_ID | Character(15) | VARCHAR2(15) NOT NULL | Lockbox ID |
| 3 | LOCKBOX_BATCH_ID | Character(5) | VARCHAR2(5) NOT NULL | Lockbox Batch Id |
| 4 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 5 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 6 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 7 | CONTROL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly. |
| 8 | CONTROL_CNT | Number(6,0) | INTEGER NOT NULL | Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly |
| 9 | RECEIVED_DT | Date(10) | DATE | Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT). |
| 10 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 11 | LOCKBOX_RUN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Lockbox Run Id |
| 12 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 13 | DATA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Data Source
820=820 ANSI-X12 APP=Accounts Payable Payment BST=Bank Statement CDR=Cash Drawer Receipts CRX=EDIFACT CREEXT LBX=Lockbox ONL=Online XEL=Excel Upload |
| 14 | LB_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | Name of Lockbox File |