VCHRACCLN_TEO2

(SQL Table)
Index Back

AP Accounting Entries

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 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".
6 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
7 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
8 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
9 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
11 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
12 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
13 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
14 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
15 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCT_BUGL_VW

16 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
18 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
19 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.
20 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
21 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.
22 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
23 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
24 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.
25 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
26 QTY_VCHR_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered in STD UOM
27 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.
28 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.
29 DESCR Character(30) VARCHAR2(30) NOT NULL Description
30 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
31 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
32 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
33 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
34 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
35 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
36 VAT_NONINV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amt Base Curr
37 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
38 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
39 CSD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
40 CSD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
41 EXD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non Recovery
42 EXD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
43 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
44 STX_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tx Amt NonRecovery in Bse Curr
45 STX_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Base Curr
46 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
47 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
48 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.
49 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
50 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

51 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.
52 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
53 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.
54 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
55 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
56 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
57 GL_DISTRIB_DTTM DateTime(26) TIMESTAMP JGen Distributed Datetime
58 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
59 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

Y/N Table Edit

Default Value: N

60 FINAL_REF_IND Character(1) VARCHAR2(1) NOT NULL Final Reference Indicator

Y/N Table Edit

Default Value: N

61 REFERENCE_NUMBER Character(10) VARCHAR2(10) NOT NULL Reference Number
62 REF_CLOSED Character(1) VARCHAR2(1) NOT NULL Reference Closed

Y/N Table Edit

63 REF_DIST_LINE Number(5,0) INTEGER NOT NULL Ref Dist Line
64 REF_LINE_NUMBER Number(5,0) INTEGER NOT NULL Reference Line Number
65 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
66 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
67 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
68 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
69 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
70 BCM_LINE_STATUS Character(2) VARCHAR2(2) NOT NULL Budget Checking Line Status

Default Value: N

71 BCM_POST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Post Amount
72 BCM_POST_AMT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Total Post Amount
73 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
74 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
75 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
76 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
77 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
78 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
79 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
80 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
81 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
82 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
83 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
84 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
85 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
86 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
87 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
88 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
89 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
90 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
91 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
92 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
93 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
94 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.
95 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
96 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
97 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
98 CSD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
99 CSD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
100 EXD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise NonRcvry Amount
101 EXD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
102 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
103 STX_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Nonrecovery
104 STX_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount
105 FREIGHT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
106 FREIGHT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
107 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
108 MISC_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
109 SALETX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
110 SALETX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
111 USETAX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
112 USETAX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
113 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
114 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount
115 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
116 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
117 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.
118 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
119 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
120 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
121 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
122 VAT_DSCNT_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj
123 VAT_DSCNT_ADJ_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
124 VAT_DSCNT_RCVRY Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj Rcvr
125 VAT_DSCNT_RCVR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
126 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.
127 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.
128 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"". "
129 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

130 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

131 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

132 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

133 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

134 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

135 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

136 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

137 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

138 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

139 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

140 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

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

Prompt Table: PROJID_BUGL_VW

142 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
143 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
144 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
145 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
146 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
147 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.
148 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
149 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
150 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
151 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
152 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
153 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.
154 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.
155 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.
156 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
157 POSTING_DATE Date(10) DATE Posting Date
158 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
159 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.
160 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

161 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

162 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open

Default Value: O

163 BUDGET_DT Date(10) DATE Budget Date
164 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
165 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
166 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
167 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
168 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
169 VAT_TRANS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Transaction Amt Reporting
170 CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Reporting Currency
171 VAT_INV_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amt in Reporting Currency
172 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).
173 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.
174 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.
175 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
176 EE_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL Entry Event Line Status

Default Value: N

177 VAT_LN_ENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Line Entered Amount
178 VAT_LN_ENT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Line Entered Amt Base Curr
179 VAT_MBASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Basis Amount
180 VAT_MBASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Basis Amt Base Curr
181 VAT_MTRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Transaction Amount
182 VAT_MTRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Trans Amt Base Curr
183 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
184 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
185 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
186 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
187 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
188 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
189 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
190 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
191 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code
192 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document