VAT_CNTXT_SEQ(SQL Table) |
Index Back |
---|---|
VAT Context: Field Sequence |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | VAT Context ID | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
3 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
4 | FIELDNAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Field Name Alias |
5 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
6 | 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 |