VAT_TXN_CD(SQL Table) |
Index Back |
|---|---|
VAT Transaction Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | VAT_TXN_TYPE_CD |
Character(4) | VARCHAR2(4) NOT NULL | VAT Transaction Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | EC_SALES_LIST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
EC Sales List Type
NA=Not Applicable NSA=Normal EC Sales SAP=Ship after Process SFP=Ship for Process TRI=Triangulation Default Value: NA |
| 6 | ACCTG_ENTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Accounting Entries
Y/N Table Edit Default Value: Y |
| 7 | VAT_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create VAT Transaction
Y/N Table Edit Default Value: Y |
| 8 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line Number |