ORD_LINE_EC

(SQL Table)
Index Back

OM Ord Line Staging

OM Ord Line Staging Date Initials Issue Description 091301 dms F-CJORGENS-11 Add REASON_CD 101201 dms R-BLOVE-XT8WQ Change product_id, prod_id_entered properties 012003 dms F-CJORGENS-43 Add csd_benefit_id, exs_tax_txn_type 052504 dms F-KNANN-V59N4 Add route info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold
5 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

7 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
8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: %EDITTABLE5

9 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
10 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDRSHP_VW

12 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
13 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm
14 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
15 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
16 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
17 CANCEL_DATE Date(10) DATE Cancel Date
18 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

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

Prompt Table: CARRIER_ID

20 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID
21 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
22 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

Prompt Table: CUST_CNCT_SH_VW

23 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: %EDITTABLE3

24 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

Prompt Table: %EDITTABLE4

25 CNTRCT_SCHED_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Schedule
26 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CFGCD_PMP_VW

27 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
28 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
29 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
30 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
31 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
32 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
33 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
34 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
35 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
36 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
37 CSD_BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL India Customs Duty Benefit Identification
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
40 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance
41 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base
42 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price
43 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base
44 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount
45 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base
46 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price
47 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base
48 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

Y/N Table Edit

49 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number

Prompt Table: PROD_CALIS3_VW

50 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
51 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
52 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

Y/N Table Edit

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

Y/N Table Edit

54 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
55 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
56 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
57 EXPORT_APPL_DT Date(10) DATE Application Date
58 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
59 EXPORT_REC_DT Date(10) DATE Date Received
60 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
61 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
62 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value
63 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity
64 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
65 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

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

Prompt Table: FREIGHT_TERMS

67 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
68 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
69 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
70 IMPORT_APPL_DT Date(10) DATE Application Date
71 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
72 IMPORT_REC_DT Date(10) DATE Date Received
73 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
74 IMPORT_LIC_EXP Date(10) DATE Expiration Date
75 INVENTORY_EDIT Character(1) VARCHAR2(1) NOT NULL Inventory Edit

Default Value: N

76 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
77 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule
78 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder
79 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule
80 INVALID_ARRV_DT Character(1) VARCHAR2(1) NOT NULL Invalid arrival date indicator
81 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Y/N Table Edit

82 ORD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled

Prompt Table: OMEC_LN_STAT_VW

83 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
84 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
85 LIST_PRICE_ORIG Signed Number(17,4) DECIMAL(15,4) NOT NULL Original List Price
86 LIST_PRICEORIG_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Orig List Price (base)
87 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
88 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.
89 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
90 NET_CHG_TO_QTY Character(1) VARCHAR2(1) NOT NULL Net Change to Quantity

Y/N Table Edit

91 NET_CHG_QTY_EP Character(1) VARCHAR2(1) NOT NULL Net Change to Quantity

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

94 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

Prompt Table: ORD_GROUP

95 ORD_LINE_TAG Number(5,0) INTEGER NOT NULL Order Line tag line nbr
96 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

Prompt Table: OM_PAY_MTHD_VW

97 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
98 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.

Prompt Table: AR_TRMS_VW

99 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
100 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
101 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
102 PRICE_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Price
103 PRICE_ORIG_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Orig Net Unit Price (base)
104 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

Y/N Table Edit

105 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM
106 PRODUCT_ID_ORIG Character(18) VARCHAR2(18) NOT NULL Original Product
107 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
108 QTY_ORDERED_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Quantity
109 QTY_PICKUP Number(16,4) DECIMAL(15,4) NOT NULL Counter sale pickup quantity
110 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_SHIP_VW

111 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
112 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
113 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
114 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.

Prompt Table: ORDENT_ROUTE_VW

115 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
116 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
117 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
118 SECTION_ID Character(20) VARCHAR2(20) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks
119 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
120 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

Prompt Table: %EDITTABLE2

121 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
122 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
123 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

Prompt Table: SHIP_PRIORITY

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

Prompt Table: SHIP_PRIORITY

125 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SLDSHP_VW

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

Prompt Table: SHIP_METHOD

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

Prompt Table: SHIP_METHOD

128 SKIP_ATP Character(1) VARCHAR2(1) NOT NULL Flag that indicates that ATP calculation will be skipped during the online reservation process.

Y/N Table Edit

Default Value: N

129 SKIP_LOT_ALLOC Character(1) VARCHAR2(1) NOT NULL Flag that indicates that lot allocation will be skipped during the online reservation process.

Y/N Table Edit

Default Value: N

130 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
131 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner
132 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
133 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
134 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
135 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed
136 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
137 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
138 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: TAX_HDR_TBL_VW

139 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group
140 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt

Default Value: 1

141 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order
142 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)
143 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)
144 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)
145 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
146 UNIT_COST_ALT Signed Number(16,4) DECIMAL(14,4) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks
147 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: PROD_UOM

148 UOM_ORIG Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
149 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID

Prompt Table: PROD_UPC_VW

150 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number

Prompt Table: PROD_UPN_VW

151 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
152 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
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_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done

Default Value: N

155 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.
156 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.
157 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.
158 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
159 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

160 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
161 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
162 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
163 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
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 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
166 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
167 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.
168 CUSTOM_C10_A Character(10) VARCHAR2(10) NOT NULL Custom Char 10A
169 CUSTOM_C10_B Character(10) VARCHAR2(10) NOT NULL Custom Char 10B
170 CUSTOM_C20_A Character(20) VARCHAR2(20) NOT NULL Custom Char 20A
171 CUSTOM_C20_B Character(20) VARCHAR2(20) NOT NULL Custom Char 20B
172 CUSTOM_C30_A Character(30) VARCHAR2(30) NOT NULL Custom Char 30A
173 CUSTOM_C30_B Character(30) VARCHAR2(30) NOT NULL Custom Char 30B
174 CUSTOM_C40_A Character(40) VARCHAR2(40) NOT NULL Custom Char 40A
175 CUSTOM_C40_B Character(40) VARCHAR2(40) NOT NULL Custom Char 40B
176 CUSTOM_C80_A Character(80) VARCHAR2(80) NOT NULL Custom Char 80A
177 CUSTOM_C80_B Character(80) VARCHAR2(80) NOT NULL Custom Char 80B
178 CUSTOM_DTTM_A DateTime(26) TIMESTAMP Custom DateTime A
179 CUSTOM_DTTM_B DateTime(26) TIMESTAMP Custom DateTime B
180 CUSTOM_DTTM_C DateTime(26) TIMESTAMP Custom DateTime C
181 CUSTOM_DTTM_D DateTime(26) TIMESTAMP Custom DateTime D
182 CUSTOM_DTTM_E DateTime(26) TIMESTAMP Custom DateTime E
183 CUSTOM_DTTM_F DateTime(26) TIMESTAMP Custom DateTime F
184 CUSTOM_DTTM_G DateTime(26) TIMESTAMP Custom DateTime G
185 CUSTOM_DTTM_H DateTime(26) TIMESTAMP Custom DateTime H
186 CUSTOM_DTTM_I DateTime(26) TIMESTAMP Custom DateTime I
187 CUSTOM_DTTM_J DateTime(26) TIMESTAMP Custom DateTime J
188 CUSTOM_DTTM_K DateTime(26) TIMESTAMP Custom DateTime K
189 CUSTOM_DTTM_L DateTime(26) TIMESTAMP Custom DateTime L
190 CUSTOM_DTTM_M DateTime(26) TIMESTAMP Custom DateTime M
191 CUSTOM_DTTM_N DateTime(26) TIMESTAMP Custom DateTime N
192 CUSTOM_DTTM_O DateTime(26) TIMESTAMP Custom DateTime O
193 CUSTOM_DTTM_P DateTime(26) TIMESTAMP Custom DateTime P
194 CUSTOM_DTTM_Q DateTime(26) TIMESTAMP Custom DateTime Q
195 CUSTOM_DTTM_R DateTime(26) TIMESTAMP Custom DateTime R
196 CUSTOM_DTTM_S DateTime(26) TIMESTAMP Custom DateTime S
197 CUSTOM_DTTM_T DateTime(26) TIMESTAMP Custom DateTime T
198 CUSTOM_N12_A Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 A
199 CUSTOM_N12_B Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 B
200 CUSTOM_N12_C Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 C
201 CUSTOM_N12_D Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 D
202 CUSTOM_N12_E Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 E
203 CUSTOM_N15_A Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 A
204 CUSTOM_N15_B Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 B
205 CUSTOM_N15_C Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 C
206 CUSTOM_N15_D Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 D
207 CUSTOM_N15_E Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 E
208 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
209 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
210 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.
211 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID