AR_IDCUST_WD(SQL Table) |
Index Back |
---|---|
AR Payload IDCust Work Doc |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ECFILEROWID | Character(3) | VARCHAR2(3) NOT NULL | Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length. |
2 | REMIT_FROM_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
3 | REMIT_FROM_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Remit From Customer |
4 | MICR_ID | Character(30) | VARCHAR2(30) NOT NULL | MICR ID |
5 | DB_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
6 | DFI_ID_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined |
7 | DFI_ID_NUM | Character(12) | VARCHAR2(12) NOT NULL | A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun |
8 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
9 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
11 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |