OMBCK_AET(SQL Table) |
Index Back |
---|---|
OM Completion AE CacheOM Completion AE Cache NOTE: No more Fields should be added to this table to to platform constraints. Add additional fields to OMBCK2_AET. Modified 5/20 yb |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
5 | EOEP_ARB_ID | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Plan |
6 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
7 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
8 | ORDER_DATE_TO | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
9 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL | Order Group |
10 | ORDER_GRP_TO | Character(6) | VARCHAR2(6) NOT NULL | Order Completion rel 9.0 |
11 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
12 | 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 |
13 | ORDER_NO_TO | Character(10) | VARCHAR2(10) NOT NULL | To Order No |
14 | ORDER_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Order Status
C=Closed O=Open P=Pending X=Canceled |
15 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
16 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
17 | PRICE_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL | Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL |
18 | PRICE_PROTECTED | Character(1) | VARCHAR2(1) NOT NULL | Price Protected |
19 | PROD_ID_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Product Source
C=Customer P=UPC S=System U=Universal |
20 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
21 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
22 | REPRICE_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Reprice Only |
23 | ROUTE_CD_OUT | 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. |
24 | ROUTE_CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Used to return the Carrier ID assigned to a given transportation route. |
25 | ROUTE_SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Used to return the Ship Via assigned to a given transportation route. |
26 | ROUTE_SCHED_DATE | Date(10) | DATE | Date on which a delivery route code can be used to fulfill orders. |
27 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
28 | SETID_INV_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
29 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
30 | SETID_MST_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Master Item SETID |
31 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
32 | SOLD_TO_CUST_ID_TO | Character(15) | VARCHAR2(15) NOT NULL | Order Completion Rel 9.0 |
33 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
34 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
35 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
36 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
37 | PRICE_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
38 | LAST_ORDER | Character(10) | VARCHAR2(10) NOT NULL | Last Order |
39 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |
40 | LIST_PRICE_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price (base) |
41 | SCHED_SHIP_DTTM | DateTime(26) | TIMESTAMP | Schedule Ship Datetime |
42 | SCHED_SHIP_ORIG | DateTime(26) | TIMESTAMP | Original Sch Ship |
43 | SCHED_SHIP_TIME | Time(15) | TIMESTAMP | Scheduled Ship Time |
44 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
45 | SCHED_ARRV_ORIG | DateTime(26) | TIMESTAMP | Original Sch Arrival |
46 | SCHED_ARRV_TIME | Time(15) | TIMESTAMP | Scheduled Arrival Time |
47 | REQ_SHIP_DTTM | DateTime(26) | TIMESTAMP | Requested Ship |
48 | REQ_ARRIVAL_DTTM | DateTime(26) | TIMESTAMP | Requested Arrival |
49 | REQ_ARRIVAL_ORIG | DateTime(26) | TIMESTAMP | Original Req Arrival |
50 | REQ_ARRIVAL_TIME | Time(15) | TIMESTAMP | Requested Arrival Time |
51 | STOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Stop Search Here |
52 | SEARCH_STOPPED | Character(1) | VARCHAR2(1) NOT NULL |
Search Stopped
Y/N Table Edit |
53 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
54 | SOURCE_CD_TO | Character(6) | VARCHAR2(6) NOT NULL | Order Completion rel9.0 |
55 | STD_DISCOUNT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Standard Discount |
56 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
57 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
58 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Address - Ship To |
59 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Address - Sold To |
60 | SUBCUST_QUAL1 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
61 | SUBCUST_QUAL2 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
62 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL | Load ID |
63 | TRNSPT_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | Transportation Lead Tm (days) |
64 | TRNSPT_LEAD_HOURS | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Hours) |
65 | TRNSPT_LEAD_MIN | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Min) |
66 | TRFT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Rule Code. |
67 | TRFT_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
68 | SHIP_TIME | Time(15) | TIMESTAMP | Ship Time |
69 | TIME_TO | Time(15) | TIMESTAMP | To Time |
70 | TIME_FROM | Time(15) | TIMESTAMP | From Time |
71 | TIME_HH | Number(2,0) | SMALLINT NOT NULL | Time - Hour |
72 | TIME_MM | Number(2,0) | SMALLINT NOT NULL | Time - Minute |
73 | SHIP_DAY | Character(1) | VARCHAR2(1) NOT NULL |
Day of Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
74 | WEEKDAY | Character(1) | VARCHAR2(1) NOT NULL |
Weekday 1
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
75 | DTTM_FROM | DateTime(26) | TIMESTAMP | From Date/Time |
76 | DTTM_TO | DateTime(26) | TIMESTAMP | To Date/Time |
77 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
78 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
79 | PRC_SCHED_DT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Scheduled Ship Date |
80 | PREF_CARRIER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Carrier flag
N=No Preferred Carrier Y=Preferred Carrier |
81 | FINAL_PRICE | Character(1) | VARCHAR2(1) NOT NULL |
Stop Price Calculation Here
N=No Y=Yes |
82 | COSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed |
83 | CP_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID Field |
84 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |
85 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
86 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
87 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
88 | CARRIER_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Carrier ID |
89 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
90 | CUSTOMER_PO_LINE | Character(11) | VARCHAR2(11) NOT NULL | Customer PO Line |
91 | CUST_PO_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Customer PO Price |
92 | CUST_PO_PRC_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Customer PO Price Base |
93 | CUST_NET_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Customer Net Price |
94 | CUST_NET_PRC_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Customer Net Price Base |
95 | CUST_OFF_INV_DISC | Signed Number(18,5) | DECIMAL(16,5) NOT NULL | Customer Off-Inv Discount |
96 | CUST_BILL_BACK_ALL | Signed Number(18,5) | DECIMAL(16,5) NOT NULL | Customer's bill-back allowance |
97 | CUST_BBACK_ALL_BSE | Signed Number(18,5) | DECIMAL(16,5) NOT NULL | Customer Bill Back Allow Base |
98 | CUST_OFF_INV_BASE | Signed Number(18,5) | DECIMAL(16,5) NOT NULL | Cust Off Invoice Disc Base |
99 | CUST_PROMO_NUM | Character(10) | VARCHAR2(10) NOT NULL | Customer Promotion Number |
100 | CUSTOMER_PO_SCHED | Character(11) | VARCHAR2(11) NOT NULL | Customer PO Schedule |
101 | FREIGHT_TERMS_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Freight Terms Code |
102 | 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. |
103 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
104 | SHIP_PRIORITY_EXP | Character(6) | VARCHAR2(6) NOT NULL | Export Shipping Priority |
105 | SHIP_TYPE_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Shipping Method |
106 | STORE_NUMBER | Character(17) | VARCHAR2(17) NOT NULL | Store Number |
107 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
108 | CR_CARD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
"See OM
01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute |
109 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
110 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
111 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
112 | SHIP_PRIORITY_ID | Character(6) | VARCHAR2(6) NOT NULL | Shipping Priority Code |
113 | 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. |
114 | 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 |
115 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
116 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
117 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
118 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
119 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
120 | ADDR_OVRD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line H=Header L=Line S=Schedule |
121 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
122 | TAX_VENDOR | Character(1) | VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware N=None V=Vertex |
123 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
124 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
125 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
126 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
127 | DST_ID_DIS | Character(10) | VARCHAR2(10) NOT NULL | Discount Distribution Code |
128 | DST_PCT_DIS | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Discount Dist Percentage |
129 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL | Revenue Dist Code |
130 | DST_PCT_REV | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Revenue Dist Percentage |
131 | DST_ID_SUR | Character(10) | VARCHAR2(10) NOT NULL | Surcharge Distribution Code |
132 | DST_PCT_SUR | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Surcharge Dist Percentage |
133 | DST_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Dist Rule Code |
134 | DISTRIB_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Set ID |
135 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
136 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
137 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
138 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
139 | REPLACEMENT_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods |
140 | PRODUCT_FAMILY | Character(1) | VARCHAR2(1) NOT NULL | Product Family |
141 | SUPPORT_TEAM_CD | Character(6) | VARCHAR2(6) NOT NULL | Support Team Code |
142 | COMMSN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Commission Method
C=Commission Percent P=Pro-Rata Percent |
143 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
144 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
145 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
146 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
147 | DROP_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Drop Ship
N=No Y=Yes |
148 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes |
149 | COMMSN_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Commissions Level
0=No Commissions 1=By Header 2=By Schedule |
150 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
151 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
152 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
153 | 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 |
154 | 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 |
155 | 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 |
156 | VAT_DFLT_WRK | Character(2) | VARCHAR2(2) NOT NULL | VAT Defaulting Work |
157 | 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. |
158 | 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. |
159 | 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. |
160 | 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 |
161 | 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. |
162 | VAT_RGSTRN_BUYER | Character(20) | VARCHAR2(20) NOT NULL | Specifies a customers VAT Registration ID for a particular country. |
163 | VAT_SUSPENSION_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use VAT Suspension |
164 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
165 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
166 | 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. |
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 | 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. |
169 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Tax Code |
170 | TAX_CUST_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tax Customer Group |
171 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
172 | EXPORT_ORDER_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag Orders for Export |
173 | SINGLE_SHIP_RES | Number(3,0) | SMALLINT NOT NULL | Single Ship Reserve |
174 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
175 | FRT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Freight Rule Code |
176 | FREIGHT_BILL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Order Entry SH=Shipping |
177 | PROD_SUBSTITUTE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Product Substitutions
N=No Y=Yes |
178 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
179 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
180 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
181 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
182 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
183 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
184 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
185 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
186 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
187 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
188 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
189 | X_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier |
190 | X_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier Location |
191 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
192 | DELIVERY_ID2 | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
193 | DEL_ORD_RESTRICTED | Character(1) | VARCHAR2(1) NOT NULL |
Deliveries restricted to order
N=Deliveries Not Restricted Y=Deliveries Restricted to Order |
194 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
195 | ADDTL_ADJ_BILLED | Character(1) | VARCHAR2(1) NOT NULL | Adjustment Amount Billed |
196 | FRT_BY_QTY | Character(1) | VARCHAR2(1) NOT NULL | Freight by Order Quantity |
197 | FRT_BY_WT | Character(1) | VARCHAR2(1) NOT NULL | Freight by Shipping Weight |
198 | FRT_BY_VOL | Character(1) | VARCHAR2(1) NOT NULL | Freight by Shipping Volume |
199 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
200 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
201 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
202 | SHIPPING_QTY | Number(17,4) | DECIMAL(16,4) NOT NULL | Shipping Quantity |
203 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
204 | SHIPPING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Volume |
205 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
206 | 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 |
207 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
208 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020 |
209 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
210 | ALLOW_OVERPICK_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used to indicate whether or not overpicking is allowed for a customer or business unit. |
211 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
212 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
213 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
214 | BLD_CLAUSE_LONG | Long Character(1024) | VARCHAR2(1024) | Concatenate Build Clause |
215 | CUST_PICKUP | Character(1) | VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No Y=Yes Y/N Table Edit |
216 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
217 | VAT_DFLT_DONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting X=Do not default Y=Defaulting Done |
218 | VAT_DS_DFLT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Process only Direct Ship VAT
N=NO Y=Y |
219 | VAT_PO_DELTA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
PO Change Options
1=Do not check for changes 2=Change - Reset VAT Defaults 3=Change - No Reset VAT 4=Report - log differences |