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.