PO_ORD_SCHEDULE

(SQL Table)
Index Back

Order Schedule Line

This record is the child of ORD_LINE. It holds all the delivery information for the order line. It also allows multiple schedules per order line so that an order line quantity may be broken out into multiple shipments on different dates, to different destinations from different warehouses.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

Default Value: 1

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SLDSHP_VW

6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

7 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDRSHP_VW

9 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_FS

10 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm
11 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
12 ATP_DATE Date(10) DATE ATP Promise Date
13 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
14 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
16 CANCEL_DATE Date(10) DATE Cancel Date
17 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: %EDITTABLE8

18 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

Prompt Table: %EDITTABLE8

19 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
20 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
21 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent
22 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
23 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
24 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
25 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

Prompt Table: VAT_ENT_REG_VW

26 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

Prompt Table: COUNTRY_VAT_VW

27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
28 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
29 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance
30 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base
31 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price
32 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base
33 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount
34 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base
35 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
36 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price
37 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base
38 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
39 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule
40 DEMAND_SENT Character(1) VARCHAR2(1) NOT NULL Demand Sent to INV

Y/N Table Edit

Default Value: N

41 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
42 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: DISTR_IBU_VW

43 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

Y/N Table Edit

Default Value: N

44 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code

Prompt Table: DSTCD_DIS_OM_VW

45 DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Dist Code

Prompt Table: DSTCD_REV_OM_VW

46 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code

Prompt Table: DSTCD_SUR_OM_VW

47 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

48 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
49 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
50 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
51 EXPORT_APPL_DT Date(10) DATE Application Date
52 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
53 EXPORT_REC_DT Date(10) DATE Date Received
54 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
55 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
56 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value
57 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity
58 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: %EDITTABLE5

59 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

Prompt Table: %EDITTABLE5

60 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
61 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
62 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
63 IMPORT_APPL_DT Date(10) DATE Application Date
64 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
65 IMPORT_REC_DT Date(10) DATE Date Received
66 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
67 IMPORT_LIC_EXP Date(10) DATE Expiration Date
68 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
69 INVOICE_DT Date(10) DATE Invoice Date
70 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
71 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
72 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
73 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
74 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: ORD_LOAD_INV_VW

75 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

Y/N Table Edit

Default Value: N

76 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
77 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
78 NET_CHG_QTY_EP Character(1) VARCHAR2(1) NOT NULL Net Change to Quantity

Y/N Table Edit

Default Value: N

79 NET_CHG_REQDT_EP Character(1) VARCHAR2(1) NOT NULL Net Change to Requested Date

Y/N Table Edit

Default Value: N

80 NET_CHG_SCHDT_EP Character(1) VARCHAR2(1) NOT NULL Net Change to Sched Ship Date

Y/N Table Edit

Default Value: N

81 NET_CHG_STATUS_EP Character(1) VARCHAR2(1) NOT NULL Net Change to Status

Y/N Table Edit

Default Value: N

82 NET_CHG_TO_QTY Character(1) VARCHAR2(1) NOT NULL Net Change to Quantity

Y/N Table Edit

Default Value: N

83 NET_CHG_TO_REQDT Character(1) VARCHAR2(1) NOT NULL Net Change to Reqst Dt

Y/N Table Edit

Default Value: N

84 NET_CHG_TO_SCHDT Character(1) VARCHAR2(1) NOT NULL Net Change to Sched Dt

Y/N Table Edit

Default Value: N

85 NET_CHG_TO_STATUS Character(1) VARCHAR2(1) NOT NULL Net Change to Status

Y/N Table Edit

Default Value: N

86 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
87 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
88 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
89 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified
90 PO_HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL PO Hold Flag

Y/N Table Edit

Default Value: N

91 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
92 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
93 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
94 PRICE_OVERRIDE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override
95 PRICE_OVERRIDE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override (base)
96 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

Prompt Table: EOEP_ARB_ID_VW

97 PRICESET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Rule Price
98 PRICESET_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Priceset Rule (base)
99 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

Y/N Table Edit

Default Value: N

100 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

101 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
102 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
103 QTY_SCHED_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Qty Scheduled
104 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

Default Value: NA

105 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
106 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival
107 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
108 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
109 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
110 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
111 REQ_SHIP_ORIG DateTime(26) TIMESTAMP Original Req Ship
112 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_RESCAT_FS

113 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: PROJ_SUBCAT_FS

114 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS

115 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
116 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
117 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
118 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival
119 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
120 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship
121 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
122 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

Prompt Table: %EDITTABLE9

123 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
124 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
125 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes
126 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
127 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

Prompt Table: %EDITTABLE6

128 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

Prompt Table: %EDITTABLE6

129 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: %EDITTABLE7

130 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

Prompt Table: %EDITTABLE7

131 SPECIAL_HANDLING Character(1) VARCHAR2(1) NOT NULL Special Handling
N=No
Y=Yes

Y/N Table Edit

Default Value: N

132 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
133 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
134 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

Prompt Table: TEAM_CODE_TBL

135 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)
136 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)
137 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)
138 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N

139 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
140 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
141 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
142 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: TAX_HEADER_TBL

143 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group

Prompt Table: CUST_TAXGPSH_VW

144 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate

Prompt Table: CUST_SHEXMPT_VW

145 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
146 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
147 VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
148 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
149 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
150 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
151 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
152 VAT_CNTRY_SUBD_FLG Character(1) VARCHAR2(1) NOT NULL Track VAT by XXXXXXXXXXXXXXXXX

Y/N Table Edit

153 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
154 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.

Prompt Table: VAT_DST_TYPE

155 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
156 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
157 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
158 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.

Y/N Table Edit

159 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
160 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
161 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
162 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable
163 VAT_TREATMENT_SAL Character(3) VARCHAR2(3) NOT NULL Describes the VAT Treatment that will be applied to this sales event. VAT treatment determines the accounting and processing that will be performed by the system. VAT treatments correspond to real world events. For example: domestic sale Distance EC Sale Export Sale.
DDS=Domestic VAT - Distance Sale
DOM=Domestic VAT
EUS=Intra-EU Sale
EUT=Intra-EU Sale Simplification
EXP=Export
OOS=Outside the Scope of VAT
164 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

Prompt Table: VAT_TXN_CD

165 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.

Prompt Table: VAT_HEADER_VW

166 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
167 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
168 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
169 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
170 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
171 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag