SAC_SS_LNDS_OUT (SQL View)	Index Back
PO Line Accounting Entries PO Line Accounting Entries

SAC_SS_LNDS_OUT

(SQL View)

PO Line Accounting Entries

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.LINE_NBR ,A.SCHED_NBR ,A.DST_ACCT_TYPE ,A.DISTRIB_LINE_NUM ,A.QTY_PO ,A.CURRENCY_CD ,A.MERCHANDISE_AMT ,A.CURRENCY_CD_BASE ,A.MERCH_AMT_BSE ,A.LOCATION ,A.ACCOUNT ,A.ALTACCT ,A.DEPTID ,%subrec(CF16_AN_SBR,A) ,A.PROJECT_ID ,A.CHARTFIELD_STATUS ,A.BUSINESS_UNIT_GL ,A.DISTRIB_LN_STATUS ,A.DIST_PROCESSED_FLG ,A.BUSINESS_UNIT_REQ ,A.BUSINESS_UNIT_PC ,A.ACTIVITY_ID ,A.REQ_ID ,A.REQ_LINE_NBR ,A.REQ_SCHED_NBR ,A.REQ_DISTRIB_NBR ,A.BUSINESS_UNIT_IN ,A.QTY_REQ ,A.DISTRIB_TYPE ,A.DISTRIB_PCT ,A.INVOICE_CLOSE_IND ,A.FINANCIAL_ASSET_SW ,A.COST_TYPE ,A.TAX_CD_SUT ,A.TAX_CD_SUT_PCT ,A.SALETX_AMT ,A.SALETX_AMT_BSE ,A.USETAX_AMT ,A.USETAX_AMT_BSE ,A.SUT_APPLICABILITY ,A.VAT_TXN_TYPE_CD ,A.VAT_APPLICABILITY ,A.TAX_CD_VAT ,A.TAX_CD_VAT_PCT ,A.VAT_AMT ,A.VAT_AMT_BASE ,A.VAT_BASIS_AMT ,A.VAT_BASIS_AMT_BSE ,A.VAT_RECOVERY_PCT ,A.VAT_RCVRY_AMT ,A.VAT_RCVRY_AMT_BSE ,A.VAT_REBATE_PCT ,A.VAT_REBATE_AMT ,A.VAT_REBATE_AMT_BSE ,A.VAT_USE_ID ,A.MONETARY_AMOUNT ,A.MONETARY_AMT_BSE ,A.BUDGET_DT ,A.BUDGET_LINE_STATUS ,A.VAT_CALC_TYPE ,A.SALETX_PRORATE_FLG ,A.USETAX_PRORATE_FLG ,A.VAT_NRCVR_PRO_FLG ,A.VAT_PRORATE_FLG ,A.VAT_RCVRY_PCT_SRC ,A.VAT_REBATE_PCT_SRC ,A.VAT_TRANS_AMT ,A.VAT_TRANS_AMT_BSE ,A.VAT_APORT_CNTRL FROM PS_SAC_SS_ERP_DS_V A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PO_HDR.BUSINESS_UNIT

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
Default Value: DST

6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
Default Value: 1

7 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

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

9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

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

11 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

13 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

14 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

16 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

19 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

20 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

21 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

22 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

23 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

24 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

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

29 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid
Default Value: V

30 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

31 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
Default Value: O

32 DIST_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Distribution Processed
Default Value: N

33 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

34 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

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

36 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

37 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

38 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

39 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

40 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

41 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

42 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

43 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage

44 INVOICE_CLOSE_IND Character(1) VARCHAR2(1) NOT NULL Invoice Close Indicator
Default Value: N

45 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
Default Value: BUS_UNIT_TBL_PM.FINANCIAL_ASSET_SW

46 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

47 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

48 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent

49 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

50 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount

51 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

52 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount

53 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated

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

55 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

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

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

58 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.

59 VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.

60 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.

61 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr

62 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent

63 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt

64 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr

65 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent

66 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt

67 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr

68 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

69 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

70 MONETARY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base

71 BUDGET_DT Date(10) DATE Budget Date

72 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
Default Value: V

73 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive

74 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax

75 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax

76 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT

77 VAT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate VAT

78 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
Default Value: A

79 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
Default Value: A

80 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.

81 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable

82 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PO_HDR.BUSINESS_UNIT
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment Default Value: DST
6	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
7	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
11	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
12	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
13	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
14	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
17	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
18	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
19	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
20	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
21	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
22	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
23	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
24	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
25	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
26	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
27	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
28	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
29	CHARTFIELD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Status R=Recycled V=Valid Default Value: V
30	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
31	DISTRIB_LN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Line Status C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled Default Value: O
32	DIST_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Processed Default Value: N
33	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
34	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
35	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
36	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
37	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
38	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
39	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
40	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
41	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
42	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
43	DISTRIB_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Distribution Percentage
44	INVOICE_CLOSE_IND	Character(1)	VARCHAR2(1) NOT NULL	Invoice Close Indicator Default Value: N
45	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize Default Value: BUS_UNIT_TBL_PM.FINANCIAL_ASSET_SW
46	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
47	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
48	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
49	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
50	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
51	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
52	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
53	SUT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicability D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated
54	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.
55	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
56	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.
57	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.
58	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
59	VAT_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
60	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
61	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
62	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
63	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
64	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
65	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
66	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
67	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt in Base Curr
68	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
69	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
70	MONETARY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
71	BUDGET_DT	Date(10)	DATE	Budget Date
72	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning Default Value: V
73	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount." E=Exclusive I=Inclusive
74	SALETX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Sales Tax
75	USETAX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Use Tax
76	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
77	VAT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate VAT
78	VAT_RCVRY_PCT_SRC	Character(1)	VARCHAR2(1) NOT NULL	VAT Recovery Percent Source A=Automatically calculated M=Manual Entry Default Value: A
79	VAT_REBATE_PCT_SRC	Character(1)	VARCHAR2(1) NOT NULL	VAT Rebate Percent Source A=Automatically calculated M=Manual Entry Default Value: A
80	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
81	VAT_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount in base currency against which the VAT is applicable
82	VAT_APORT_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	VAT Apportionment Control D=Distribution GL Business Unit G=Transaction GL Business Unit T=Transaction Business Unit