AR_EDEP_ERR_VW(SQL View) |
Index Back |
|---|---|
AR WorkCenter Filter |
| SELECT DISTINCT LB_BANK_TRANS_ID , LOCKBOX_ID , LOCKBOX_BATCH_ID , DEPOSIT_BU , BNK_ID_NBR , BANK_ACCOUNT_NUM , RECEIVED_DT , ACCOUNTING_DT , PROCESS_INSTANCE , DATA_SOURCE FROM PS_AR_PAYMENT_EC WHERE PROCESS_INSTANCE = 9999999999 |
| # | 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 | 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). |
| 8 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 10 | 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 |