VCH_ACT_HDR_VW1

#	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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
54	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Y/N Table Edit Default Value: N
55	FINAL_REF_IND	Character(1)	VARCHAR2(1) NOT NULL	Final Reference Indicator Y/N Table Edit Default Value: N
56	REFERENCE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Reference Number
57	REF_CLOSED	Character(1)	VARCHAR2(1) NOT NULL	Reference Closed Y/N Table Edit
58	REF_DIST_LINE	Number(5,0)	INTEGER NOT NULL	Ref Dist Line
59	REF_LINE_NUMBER	Number(5,0)	INTEGER NOT NULL	Reference Line Number
60	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
61	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
62	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
63	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
64	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
65	BCM_LINE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Budget Checking Line Status Default Value: N
66	BCM_POST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BCM Post Amount
67	BCM_POST_AMT_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BCM Total Post Amount
68	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
69	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
70	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
71	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
72	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
73	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
74	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
75	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
76	ASSET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Assets Applicable
77	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
78	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
79	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
80	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
81	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
82	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
83	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
84	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
85	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
86	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
87	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
88	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
89	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.
90	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
91	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
92	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
93	CSD_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty NonRecovery Amount
94	CSD_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Custom Duty Recovery Amount
95	EXD_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise NonRcvry Amount
96	EXD_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Recovery Amount
97	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
98	STX_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Nonrecovery
99	STX_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amount
100	FREIGHT_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
101	FREIGHT_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
102	MISC_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
103	MISC_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
104	SALETX_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
105	SALETX_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
106	USETAX_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
107	USETAX_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
108	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
109	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non-Invoice Amount
110	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
111	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
112	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.
113	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
114	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
115	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
116	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
117	VAT_DSCNT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj
118	VAT_DSCNT_ADJ_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discount Adjust Base Curr
119	VAT_DSCNT_RCVRY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj Rcvr
120	VAT_DSCNT_RCVR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discnt Recovery Base Curr
121	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.
122	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.
123	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"". "
124	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
125	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
126	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
127	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
128	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
129	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
130	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
131	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
132	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
133	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
134	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
135	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
136	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJID_BUGL_VW
137	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
138	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
139	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
140	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt in Base Curr
141	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
142	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.
143	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
144	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
145	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
146	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
147	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
148	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.
149	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.
150	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.
151	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
152	POSTING_DATE	Date(10)	DATE	Posting Date
153	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
154	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.
155	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
156	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
157	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open Default Value: O
158	BUDGET_DT	Date(10)	DATE	Budget Date
159	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
160	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
161	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
162	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
163	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
164	VAT_TRANS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Transaction Amt Reporting
165	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency
166	VAT_INV_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amt in Reporting Currency
167	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).
168	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.
169	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.
170	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
171	EE_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Entry Event Line Status Default Value: N
172	VAT_LN_ENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Line Entered Amount
173	VAT_LN_ENT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Line Entered Amt Base Curr
174	VAT_MBASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Basis Amount
175	VAT_MBASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Basis Amt Base Curr
176	VAT_MTRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Transaction Amount
177	VAT_MTRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Memo Trans Amt Base Curr
178	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
179	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
180	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
181	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
182	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
183	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
184	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
185	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
186	KK_PROCESS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Process Prior Document
187	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
188	QTY_VCHR_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered in STD UOM