IN_DEL_BKTWQ_VW (SQL View)	Index Back
Inventory Demand Fulfillment

IN_DEL_BKTWQ_VW

(SQL View)

Inventory Demand Fulfillment

SELECT D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.INV_ITEM_ID , D.DEMAND_LINE_NO , D.DELIVERY_ID , M.SETID , B.SOFT_ALLOC_FLG , I.SOFT_ALLOC_FLG , S.QTY_SCHEDULED , S.ORD_SCH_STATUS , S.TRFT_SRC_TYPE , S.TRFT_DISPOSITION , S.DROP_SHIP_FLAG , S.DEL_ORD_RESTRICTED , S.BACKGROUND_REQD , S.SOURCE_CD , S.NET_UNIT_PRICE , D.CURRENCY_CD , S.NET_UNIT_PRICE_BSE , %Sql(IN_OM_FIELD_CASE,D,S,CURRENCY_CD_BASE,D.CURRENCY_CD) , %Sql(IN_OM_FIELD_CASE,D,S,CUST_PICKUP,'N') , S.DOC_REFNUM , S.FREIGHT_BILL_TYPE , S.ORDER_TYPE_CD , S.SINGLE_SHIP_FLAG , S.PREF_CARRIER_FLAG , %subrec(OM_VAT_FLD_SBR, S) , S.PHYSICAL_NATURE , S.IDENTIFIER , %Sql(IN_WORKING_QTY_CASE, WQ,I,B,S,M) , %Sql(IN_SHIP_WORKING_QTY_CASE, WQ,I,B,S,M) , WQ.QTY_PACKED , WQ.QTY_PACK_BASE , WQ.QTY_PACK_SHIP , WQ.UNIT_MEASURE_ORD , WQ.UNIT_MEASURE_SHIP , WQ.USE_STD_UOM_FLAG , %Sql(IN_OM_FIELD_CASE,D,S,RATE_DATE,%CurrentDateIn) , %Sql(IN_OM_FIELD_CASE,D,S,RT_TYPE,BU.CUR_RT_TYPE) , %Sql(IN_OM_FIELD_CASE,D,S,RATE_MULT,1) , %Sql(IN_OM_FIELD_CASE,D,S,RATE_DIV,1) FROM PS_IN_DEMAND D JOIN PS_SET_CNTRL_REC SR ON SR.SETCNTRLVALUE = D.BUSINESS_UNIT AND SR.RECNAME = 'MASTER_ITEM_TBL' JOIN PS_MASTER_ITEM_TBL M ON SR.SETID = M.SETID AND M.INV_ITEM_ID = D.INV_ITEM_ID LEFT OUTER JOIN PS_DF_SETUP_IT_INV I ON I.BUSINESS_UNIT = D.BUSINESS_UNIT AND I.INV_ITEM_ID = D.INV_ITEM_ID JOIN PS_DF_SETUP_INV B ON B.BUSINESS_UNIT = D.BUSINESS_UNIT LEFT OUTER JOIN PS_OM_DEL_SCH_VW S ON %Join(COMMON_KEYS, IN_DEMAND D, OM_DEL_SCH_VW S) AND S.DEMAND_SENT = 'Y' AND S.SETID_INV_ITEM = M.SETID JOIN PS_IN_DEL_DQTYNVW WQ ON %Join(COMMON_KEYS, IN_DEL_DQTYNVW WQ, IN_DEMAND D) JOIN PS_BUS_UNIT_TBL_IN BU ON BU.BUSINESS_UNIT = D.BUSINESS_UNIT WHERE D.IN_FULFILL_STATE BETWEEN '10' AND '60' AND D.IN_PROCESS_DATE IS NOT NULL AND D.APPROVED_FLAG = 'Y' AND D.RESERVE_STATUS < '99'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

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
Prompt Table: SP_BU_FS_NONVW

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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: BU_ITM_INV_VW2

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

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

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

11 SOFT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Soft Reserve

12 SOFT_ALLOC_FLG2 Character(1) VARCHAR2(1) NOT NULL Soft Reserve

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

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

15 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

50 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

51 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

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

53 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

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

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

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

57 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

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

59 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

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

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

62 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

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

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

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

66 DELIV_WORK_QTY Number(16,4) DECIMAL(15,4) NOT NULL Delivery Working Quantity

67 DELIV_WK_QTY_SHIP Number(16,4) DECIMAL(15,4) NOT NULL Delivery Shipped Work Qty

68 DELIV_QTY_PACK Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed

69 DELIV_QTY_PACK_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed Base

70 DELIV_QTY_PACK_SHP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed Shipped

71 DELIV_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Order Qty UOM

72 DELIV_SHIP_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Ship Qty UOM

73 USE_STD_UOM_FLAG Character(1) VARCHAR2(1) NOT NULL Use Standard UOM

74 RATE_DATE Date(10) DATE Exchange Rate Date

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
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 Prompt Table: SP_BU_FS_NONVW
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	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW2
8	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
9	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
10	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
11	SOFT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
12	SOFT_ALLOC_FLG2	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
13	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
14	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
15	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
16	TRFT_DISPOSITION	Character(1)	VARCHAR2(1) NOT NULL	Supply Source disposition 1=Direct Ship 2=Direct Receipt
17	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship N=No Y=Yes
18	DEL_ORD_RESTRICTED	Character(1)	VARCHAR2(1) NOT NULL	Deliveries restricted to order N=Deliveries Not Restricted Y=Deliveries Restricted to Order
19	BACKGROUND_REQD	Character(1)	VARCHAR2(1) NOT NULL	Background Process Required E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes
20	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
21	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
24	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
25	CUST_PICKUP	Character(1)	VARCHAR2(1) NOT NULL	Counter sale customer pickup flag N=No Y=Yes
26	DOC_REFNUM	Character(20)	VARCHAR2(20) NOT NULL	Counter sale document reference number
27	FREIGHT_BILL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Freight Bill Type OE=Order Entry SH=Shipping
28	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
29	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
30	PREF_CARRIER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Carrier flag N=No Preferred Carrier Y=Preferred Carrier
31	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
32	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
33	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
34	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
35	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
36	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
37	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
38	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
39	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
40	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
41	VAT_DFLT_DONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaulting Done N=Awaiting Defaulting X=Do not default Y=Defaulting Done
42	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.
43	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
44	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
45	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
46	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes
47	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
48	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.
49	TAX_CD_VAT_RVC	Character(8)	VARCHAR2(8) NOT NULL	Reverse Charge VAT Code
50	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
51	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
52	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.
53	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
54	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
55	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
56	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group
57	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
58	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.
59	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
60	VAT_RVRSE_CHG_GDS	Character(1)	VARCHAR2(1) NOT NULL	VAT Reverse Charge goods flag
61	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
62	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
63	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.
64	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
65	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
66	DELIV_WORK_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Working Quantity
67	DELIV_WK_QTY_SHIP	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Shipped Work Qty
68	DELIV_QTY_PACK	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed
69	DELIV_QTY_PACK_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed Base
70	DELIV_QTY_PACK_SHP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed Shipped
71	DELIV_UOM_QTY	Character(3)	VARCHAR2(3) NOT NULL	Delivery Order Qty UOM
72	DELIV_SHIP_UOM_QTY	Character(3)	VARCHAR2(3) NOT NULL	Delivery Ship Qty UOM
73	USE_STD_UOM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Standard UOM
74	RATE_DATE	Date(10)	DATE	Exchange Rate Date
75	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.
76	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
77	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor