AP_ARC_DIST_L_H

(SQL Table)
Index Back

Voucher Distribution Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

Default Value: 1

6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

7 SUSPENSE_REF_NUM Number(5,0) INTEGER NOT NULL Suspense Reference Number
8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
10 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
11 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.
12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
13 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.
14 DSCNT_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
15 FREIGHT_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
16 MEMO_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Memo Amount
17 MISC_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
18 SALETX_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
19 USETAX_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
20 VAT_DSCNT_ADJ_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
21 VAT_DSCNT_RCVR_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
22 VAT_INV_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount Base Sum
23 VAT_NONINV_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-invoice Amt Base Sum
24 VAT_RCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt Base Sum
25 VAT_NRCVR_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
26 VAT_REBATE_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt Base Sum
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 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
29 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.
30 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item

Default Value: N

31 DESCR Character(30) VARCHAR2(30) NOT NULL Description
32 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
33 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
34 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
35 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
36 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

38 REFERENCE_NUMBER Character(10) VARCHAR2(10) NOT NULL Reference Number
39 REF_CLOSED Character(1) VARCHAR2(1) NOT NULL Reference Closed

Y/N Table Edit

Default Value: N

40 REF_DIST_LINE Number(5,0) INTEGER NOT NULL Ref Dist Line
41 REF_LINE_NUMBER Number(5,0) INTEGER NOT NULL Reference Line Number
42 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
43 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
44 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
45 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
46 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
47 BCM_LINE_STATUS Character(2) VARCHAR2(2) NOT NULL Budget Checking Line Status

Default Value: N

48 BCM_POST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Post Amount
49 BCM_POST_AMT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Total Post Amount
50 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

53 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

54 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

55 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

56 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

57 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
58 CUR_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Inter Unit Exchange Rate
59 CUR_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Interunit excahnge divisor
60 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
61 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable

Y/N Table Edit

Default Value: N

62 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
63 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
64 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
65 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
66 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.
67 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
68 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
69 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
70 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
71 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount
72 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
73 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
74 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
75 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
76 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
77 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
78 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.
79 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
80 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
81 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
82 VAT_DSCNT_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj
83 VAT_DSCNT_RCVRY Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj Rcvr
84 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.
85 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.
86 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
87 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
88 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
89 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
90 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
91 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

103 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
104 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
105 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
106 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
107 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
108 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
109 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
110 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
111 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
112 SALETX_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated Sales Tax Amount
113 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
114 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
115 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
116 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
117 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
118 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.
119 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
120 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.
121 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
122 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
123 MONETARY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base
124 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
125 MERCH_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount In GL Bus Unit Currency
126 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
127 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
128 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
129 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
130 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
131 VAT_NONINV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amt Base Curr
132 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
133 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
134 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
135 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
136 VAT_DSCNT_ADJ_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
137 VAT_DSCNT_RCVR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
138 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
139 VAT_NR_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
140 VAT_NR_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
141 VAT_NR_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
142 USETAX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
143 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
144 USETAX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
145 USETAX_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Prorated UseTax in the currency of the GL Business Unit of the Distribution Line.
146 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
147 MISC_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
148 MISC_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Prorated Misc Charges in the currency of the GL Business Unit of the Distribution Line.
149 MEMO_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Memo Amount
150 MEMO_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Memo Amt Base
151 FREIGHT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
152 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
153 SALETX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
154 FREIGHT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
155 FREIGHT_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Prorated Freight in the currency of the GL Business Unit of the Distribution Line.
156 SALETX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
157 SALETX_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Prorated Sales Tax in the currency of the GL Business Unit of the Distribution Line.
158 SALETX_CLC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated Sales Tax Base Amt
159 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
160 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
161 BUDGET_DT Date(10) DATE Budget Date
162 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
163 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
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_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
166 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
167 VAT_TRANS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Transaction Amt Reporting
168 CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Reporting Currency
169 VAT_INV_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amt in Reporting Currency
170 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
171 DSCNT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL DiscountAmount
172 DSCNT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL NonproratedDiscountAmount
173 DSCNT_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Prorated Discounts in the currency of the GL Business Unit of the Distribution Line.
174 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
175 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

Y/N Table Edit

Default Value: N

176 KK_CLOSE_PRIOR Character(1) VARCHAR2(1) NOT NULL Close Prior Transaction

Y/N Table Edit

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 USER_VCHR_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
184 USER_VCHR_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field 2
185 USER_VCHR_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field
186 USER_VCHR_DATE Date(10) DATE User Date
187 USER_VCHR_NUM1 Number(3,0) SMALLINT NOT NULL User Number field
188 DOC_TOL_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Document Line Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid

Default Value: V

189 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
190 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
191 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
192 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
193 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
194 CUSTOM_DATE_D Date(10) DATE Custom Date
195 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
196 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

Default Value: P

197 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
198 STX_TAX_AUTH_RPT Character(8) VARCHAR2(8) NOT NULL Reporting Authority (India Sales Tax)
199 EXD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax Amount
200 EXD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty in Base Currency
201 EXD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty Amt In Rpt Curr
202 EXD_TAX_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax GL Amount
203 EXD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amt
204 EXD_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount - Base
205 EXD_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount
206 EXD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
207 EXD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
208 EXD_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
209 EXD_RCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery GL Amount
210 EXD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise NonRcvry Amount
211 EXD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non Recovery
212 EXD_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non-Recovery
213 EXD_NRCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non-Recovery GL Amount
214 STX_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
215 STX_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN BASE CURR
216 STX_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN REPORT CURR
217 STX_TAX_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax GL Amount
218 STX_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount
219 STX_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Base Curr
220 STX_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Rpt Curr
221 STX_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount
222 STX_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Base Curr
223 STX_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Rpt Curr
224 STX_RCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Recovery GL Amount
225 STX_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Nonrecovery
226 STX_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tx Amt NonRecovery in Bse Curr
227 STX_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax NonRecovery
228 STX_NRCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Non-Recovery GL Amt
229 CSD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Tax Amount
230 CSD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Base
231 CSD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Reporting
232 CSD_TAX_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty GL Amount
233 CSD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Amount for Customs duty and Sales Tax
234 CSD_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Amount for Customs Duty and Sales Tax in Base Currency
235 CSD_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Amount for Customs Duty and Sales Tax in Reporting Currency
236 CSD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
237 CSD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
238 CSD_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
239 CSD_RCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery GL Amount
240 CSD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
241 CSD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
242 CSD_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
243 CSD_NRCVRY_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Non-Recovery GL
244 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done

Y/N Table Edit

Default Value: N

245 MONETARY_AMOUNT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount 2
246 FOREIGN_AMOUNT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Foreign Amount 2
247 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

248 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

249 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

250 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
251 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE

252 QTY_VCHR_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered in STD UOM
253 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
254 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
255 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
256 SPS_TAS Character(27) VARCHAR2(27) NOT NULL Sender Treasury Account Symbol
257 SPS_BETC Character(8) VARCHAR2(8) NOT NULL Sender Business Event Type
258 START_DT_2 Date(10) DATE Start Date
259 END_DT_2 Date(10) DATE End Date
260 AMORT_TYPE Character(4) VARCHAR2(4) NOT NULL Amortization Type

Prompt Table: AMR_TYPE_DVW

261 AMORTIZATION_ID Character(10) VARCHAR2(10) NOT NULL Amortization ID