VCHR_ACCTLN_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
5	POSTING_PROCESS	Character(4)	VARCHAR2(4) NOT NULL	Posting Process ACAV=Period End Accruals ACCR=AP Accrual CANC=Payment Cancelations CASH=Cash Clearing CLOS=Voucher Closure DFTA=Draft Accrual PCAD=Card PPAY=Prepaid Reversals PREP=Prepaids PYMN=Payments RACC=Receipt Accrual RCVL=Revaluation REVL=Revaluations VOID=Void WTHA=Withholding Accrual
6	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
7	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
9	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
10	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
13	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_BUGL_VW
14	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
17	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
18	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
19	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.
20	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
21	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
22	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.
23	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
24	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
25	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
26	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
27	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
28	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
29	DSCNT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Amount
30	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
31	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
32	VAT_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amt Base Curr
33	VAT_NONINV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non-Invoice Amt Base Curr
34	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
35	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
36	CSD_NRCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty NonRecovery Amount
37	CSD_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty Recovery Amount
38	EXD_NRCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Non Recovery
39	EXD_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Recovery Amount
40	MISC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
41	STX_NRCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tx Amt NonRecovery in Bse Curr
42	STX_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amt in Base Curr
43	CHART_EDIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Chart Edit Status K=Errors - Cannot be saved O=ChartFields Valid R=Errors - Not Postable S=Errors - Suspense Entries
44	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
45	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
46	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
47	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
48	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
49	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
50	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
51	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
52	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
53	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime Default Value: %Datetime
54	GL_DISTRIB_DTTM	DateTime(26)	TIMESTAMP	JGen Distributed Datetime
55	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
56	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Y/N Table Edit Default Value: N
57	FINAL_REF_IND	Character(1)	VARCHAR2(1) NOT NULL	Final Reference Indicator Y/N Table Edit Default Value: N
58	REFERENCE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Reference Number
59	REF_CLOSED	Character(1)	VARCHAR2(1) NOT NULL	Reference Closed Y/N Table Edit
60	REF_DIST_LINE	Number(5,0)	INTEGER NOT NULL	Ref Dist Line
61	REF_LINE_NUMBER	Number(5,0)	INTEGER NOT NULL	Reference Line Number
62	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
63	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
64	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
65	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
66	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
67	BCM_LINE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Budget Checking Line Status Default Value: N
68	BCM_POST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BCM Post Amount
69	BCM_POST_AMT_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BCM Total Post Amount
70	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
71	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
72	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
73	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
74	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
75	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
76	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
77	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
78	ASSET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Assets Applicable
79	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
80	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
81	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
82	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
83	AM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AM Distribution Status D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed
84	VAT_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	VAT Distribution Status D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined
85	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
86	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
87	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
88	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
89	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
90	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
91	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.
92	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
93	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
94	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
95	CSD_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty NonRecovery Amount
96	CSD_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty Recovery Amount
97	EXD_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise NonRcvry Amount
98	EXD_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Recovery Amount
99	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
100	STX_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Nonrecovery
101	STX_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amount
102	FREIGHT_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
103	FREIGHT_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
104	MISC_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
105	MISC_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
106	SALETX_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
107	SALETX_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
108	USETAX_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
109	USETAX_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
110	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
111	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non-Invoice Amount
112	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
113	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
114	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.
115	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
116	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
117	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
118	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
119	VAT_DSCNT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj
120	VAT_DSCNT_ADJ_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discount Adjust Base Curr
121	VAT_DSCNT_RCVRY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj Rcvr
122	VAT_DSCNT_RCVR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discnt Recovery Base Curr
123	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.
124	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.
125	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
126	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
127	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
128	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
129	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
130	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
131	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
132	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
133	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
134	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
135	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
136	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
137	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
138	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJID_BUGL_VW
139	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
140	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
141	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
142	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt in Base Curr
143	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
144	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.
145	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
146	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
147	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
148	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
149	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
150	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
151	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
152	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
153	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
154	POSTING_DATE	Date(10)	DATE	Posting Date
155	IST_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Distribution Status A=Awaiting Arrival Processing D=Distributed I=Ignored M=Archival Entry N=Not Distributed R=Reversal Entry S=Awaiting Dispatch Processing U=Undefined
156	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
157	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: V
158	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
159	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open Default Value: O
160	BUDGET_DT	Date(10)	DATE	Budget Date
161	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
162	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
163	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
164	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
165	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
166	VAT_TRANS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Transaction Amt Reporting
167	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency
168	VAT_INV_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amt in Reporting Currency
169	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
170	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
171	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
172	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
173	EE_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Entry Event Line Status Default Value: N
174	VAT_LN_ENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Line Entered Amount
175	VAT_LN_ENT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Line Entered Amt Base Curr
176	VAT_MBASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Basis Amount
177	VAT_MBASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Basis Amt Base Curr
178	VAT_MTRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Transaction Amount
179	VAT_MTRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Trans Amt Base Curr
180	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
181	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
182	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
183	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
184	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
185	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
186	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
187	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
188	KK_PROCESS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Process Prior Document
189	FED_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	GL Federal Reporting distribution status for SF 224. 0=Original Distribution 1=Supplemental 1 Distribution 2=Supplemental 2 Distribution 3=Supplemental 3 Distribution 4=Supplemental 4 Distribution 5=Supplemental 5 Distribution 6=Supplemental 6 Distribution 7=Supplemental 7 Distribution 8=Supplemental 8 Distribution 9=Supplemental 9 Distribution N=Not Distributed Default Value: N
190	QTY_VCHR_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered in STD UOM
191	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %Datetime