OM_DEL_SCH_VW (SQL View)	Index Back
OM Schedules for deliveries.

OM_DEL_SCH_VW

(SQL View)

OM Schedules for deliveries.

SELECT S.SHIP_FROM_BU , 'OM' , S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , P.SETID , P.INV_ITEM_ID , S.ADDRESS_SEQ_NUM , S.CARRIER_ID , S.CARRIER_ID_EXP , S.CURRENCY_CD , S.CURRENCY_CD_BASE , S.CUST_PICKUP , S.DOC_REFNUM , H.FREIGHT_BILL_TYPE , S.FREIGHT_TERMS , S.FREIGHT_TERMS_EXP , S.FRT_CHRG_METHOD , S.LOAD_ID , H.ORDER_TYPE_CD , L.PRODUCT_ID , S.ROUTE_CD , S.ROUTE_STOP_NBR , S.SCHED_SHIP_DTTM , S.SCHED_ARRV_DTTM , H.SOLD_TO_CUST_ID , S.SHIP_TO_CUST_ID , S.SHIP_TYPE_ID , S.SHIP_TYPE_ID_EXP , L.PHYSICAL_NATURE , ' ' , S.ADDR_OVRD_LEVEL , H.DEL_ORD_RESTRICTED , H.BACKGROUND_REQD , H.SOURCE_CD , S.DEMAND_SENT , S.DROP_SHIP_FLAG , S.FRT_RULE_CD , S.ORD_SCH_STATUS , S.PREF_CARRIER_FLAG , S.TRFT_SRC_TYPE , S.TRFT_DISPOSITION , S.QTY_SCHEDULED , S.NET_UNIT_PRICE , S.NET_UNIT_PRICE_BSE , S.SHIPPING_KIT_QTY , S.SHIPPING_QTY , S.SHIPPING_VOLUME , S.SHIPPING_WEIGHT , H.SINGLE_SHIP_FLAG , S.EXPORT , L.UNIT_OF_MEASURE , S.UNIT_MEASURE_SHIP , S.UNIT_MEASURE_VOL , S.UNIT_MEASURE_WT , H.RATE_DATE , H.RT_TYPE , H.RATE_MULT , H.RATE_DIV , P.PRODUCT_KIT_FLAG , P.CFG_KIT_FLAG , B.IN_FRT_USAGE , S.CUSTOMER_PO , S.CUSTOMER_PO_LINE , S.CUSTOMER_PO_SCHED , L.CUSTOMER_ITEM_NBR , L.UPC_ID , L.UPN_ID , S.EXPORT_LIC_EXPIRE , S.EXPORT_LIC_NBR , S.EXPORT_LIC_TYPE , %subrec(OM_VAT_FLD_SBR, S) , S.DELIVERY_ID FROM PS_ORD_HEADER H , PS_ORD_SCHEDULE S , PS_ORD_LINE L , PS_PROD_ITEM P , PS_BUS_UNIT_TBL_OM B WHERE %Join(COMMON_KEYS, ORD_HEADER H, ORD_SCHEDULE S) AND %Join(COMMON_KEYS, ORD_LINE L, ORD_SCHEDULE S) AND P.PRODUCT_ID = L.PRODUCT_ID AND B.BUSINESS_UNIT = H.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

4 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

5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

7 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID

8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

10 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

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

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

14 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

15 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number

16 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping

17 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

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

19 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

20 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

21 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order

22 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

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

24 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

25 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

26 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm

27 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

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

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

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

31 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

32 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier

33 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

34 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order

35 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes

36 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

37 DEMAND_SENT Character(1) VARCHAR2(1) NOT NULL Demand Sent to INV

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

39 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code

40 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled

41 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier

42 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

43 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt

44 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled

45 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

46 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

47 SHIPPING_KIT_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity

48 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity

49 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume

50 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

51 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

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

53 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

54 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure

55 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

56 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

57 RATE_DATE Date(10) DATE Exchange Rate Date

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

59 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

60 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

61 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

62 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit

63 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both

64 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

65 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line

66 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule

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

68 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID

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

70 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

71 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

72 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

73 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner

74 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner

75 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

76 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

77 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed

78 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner

79 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner

80 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State

81 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State

82 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed

83 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done

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

85 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

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

87 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country

88 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

89 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State

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

91 TAX_CD_VAT_RVC Character(8) VARCHAR2(8) NOT NULL Reverse Charge VAT Code

92 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

93 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

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

95 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

96 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

97 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

98 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group

99 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

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

101 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

102 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag

103 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication

104 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

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

106 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
3	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
4	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
5	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
6	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
7	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
11	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
14	CUST_PICKUP	Character(1)	VARCHAR2(1) NOT NULL	Counter sale customer pickup flag N=No Y=Yes
15	DOC_REFNUM	Character(20)	VARCHAR2(20) NOT NULL	Counter sale document reference number
16	FREIGHT_BILL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Freight Bill Type OE=Order Entry SH=Shipping
17	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
18	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
19	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
20	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
21	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
22	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
23	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.
24	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
25	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
26	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
27	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
28	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
29	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
30	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
31	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
32	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
33	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
34	DEL_ORD_RESTRICTED	Character(1)	VARCHAR2(1) NOT NULL	Deliveries restricted to order N=Deliveries Not Restricted Y=Deliveries Restricted to Order
35	BACKGROUND_REQD	Character(1)	VARCHAR2(1) NOT NULL	Background Process Required E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes
36	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
37	DEMAND_SENT	Character(1)	VARCHAR2(1) NOT NULL	Demand Sent to INV
38	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship N=No Y=Yes
39	FRT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Freight Rule Code
40	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
41	PREF_CARRIER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Carrier flag N=No Preferred Carrier Y=Preferred Carrier
42	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
43	TRFT_DISPOSITION	Character(1)	VARCHAR2(1) NOT NULL	Supply Source disposition 1=Direct Ship 2=Direct Receipt
44	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
45	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
46	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
47	SHIPPING_KIT_QTY	Number(17,4)	DECIMAL(16,4) NOT NULL	Shipping Quantity
48	SHIPPING_QTY	Number(17,4)	DECIMAL(16,4) NOT NULL	Shipping Quantity
49	SHIPPING_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Volume
50	SHIPPING_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Weight
51	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
52	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes
53	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
54	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure
55	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM
56	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
57	RATE_DATE	Date(10)	DATE	Exchange Rate Date
58	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.
59	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
60	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
61	PRODUCT_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Kit
62	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit
63	IN_FRT_USAGE	Character(2)	VARCHAR2(2) NOT NULL	Indicator of internal or external freight 10=Internal 20=External 30=None 40=Both
64	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
65	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
66	CUSTOMER_PO_SCHED	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Schedule
67	CUSTOMER_ITEM_NBR	Character(18)	VARCHAR2(18) NOT NULL	Customer Item Number
68	UPC_ID	Character(18)	VARCHAR2(18) NOT NULL	Uniform Product Code ID
69	UPN_ID	Character(20)	VARCHAR2(20) NOT NULL	Universal Product Number
70	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
71	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
72	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
73	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
74	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
75	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
76	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
77	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
78	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
79	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
80	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
81	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
82	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
83	VAT_DFLT_DONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaulting Done N=Awaiting Defaulting X=Do not default Y=Defaulting Done
84	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.
85	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
86	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
87	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
88	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes
89	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
90	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.
91	TAX_CD_VAT_RVC	Character(8)	VARCHAR2(8) NOT NULL	Reverse Charge VAT Code
92	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
93	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
94	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.
95	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
96	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
97	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
98	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group
99	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
100	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.
101	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
102	VAT_RVRSE_CHG_GDS	Character(1)	VARCHAR2(1) NOT NULL	VAT Reverse Charge goods flag
103	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
104	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
105	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.
106	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID