PO_CMVATCLC_AET(SQL Table) |
Index Back |
---|---|
PO_CMVATCLC_AET Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | CHARTFIELD_PR1 | Character(18) | VARCHAR2(18) NOT NULL | Chartfield Priority 1 |
3 | CHARTFIELD_PR2 | Character(18) | VARCHAR2(18) NOT NULL | Chartfield Priority 2 |
4 | PRODUCT_FAMILY | Character(1) | VARCHAR2(1) NOT NULL | Product Family |
5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
6 | PRCS_OPTION_ID | Character(5) | VARCHAR2(5) NOT NULL | Processing Option ID |
7 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
9 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
10 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
12 | PO_DT | Date(10) | DATE | Date |
13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
14 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |
15 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
16 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
17 | SETID_APORT | Character(5) | VARCHAR2(5) NOT NULL | SetID |
18 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
19 | VAT_DFLT_WRK | Character(2) | VARCHAR2(2) NOT NULL | VAT Defaulting Work |
20 | RETURN_CD | Character(1) | VARCHAR2(1) NOT NULL |
Return Code
0=Return OK 1=Return error |
21 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
22 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
23 | ERROR_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field with an error. |