| # |
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 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 4 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line Number
|
| 5 |
SUSPENSE_REF_NUM |
Number(5,0) |
INTEGER NOT NULL |
Suspense Reference Number
|
| 6 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 7 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 8 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 9 |
FOREIGN_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Foreign Amount
|
| 10 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 11 |
MONETARY_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Monetary Amount
|
| 12 |
DSCNT_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 13 |
FREIGHT_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 14 |
MEMO_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amount
|
| 15 |
MISC_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc.. Amount
|
| 16 |
SALETX_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 17 |
USETAX_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use tax GL amount.
|
| 18 |
VAT_DSCNT_ADJ_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount adjust base.
|
| 19 |
VAT_DSCNT_RCVR_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount recovery base.
|
| 20 |
VAT_INV_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT invoice amount base sum.
|
| 21 |
VAT_NONINV_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non-invoice amt base sum.
|
| 22 |
VAT_RCVRY_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT recovery amount base sum.
|
| 23 |
VAT_NRCVR_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non recoverable amount.
|
| 24 |
VAT_REBATE_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT rebate amount base.
|
| 25 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Statistic Amount
|
| 26 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 27 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Line Reference
|
| 28 |
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
|
| 29 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 30 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
|
| 31 |
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
|
| 32 |
ACCOUNTING_DT |
Date(10) |
DATE |
Accounting Date
|
| 33 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 34 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 35 |
FINAL_REF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Reference Indicator
Y/N Table Edit
Default Value: N
|
| 36 |
REFERENCE_NUMBER |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference Number
|
| 37 |
REF_CLOSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reference Closed
Y/N Table Edit
Default Value: N
|
| 38 |
REF_DIST_LINE |
Number(5,0) |
INTEGER NOT NULL |
Ref Dist Line
|
| 39 |
REF_LINE_NUMBER |
Number(5,0) |
INTEGER NOT NULL |
Reference Line Number
|
| 40 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 41 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 42 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 43 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 44 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 45 |
BCM_LINE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Budget Checking Line Status
Default Value: N
|
| 46 |
BCM_POST_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
BCM Post Amount
|
| 47 |
BCM_POST_AMT_TOT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
BCM Total Post Amount
|
| 48 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
|
| 49 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 50 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 51 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
|
| 52 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
|
| 53 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
|
| 54 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 55 |
CUR_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Inter Unit Exchange Rate
|
| 56 |
CUR_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Inter Unit Exchange Divisor
|
| 57 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 58 |
ASSET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assets Applicable
Y/N Table Edit
Default Value: N
|
| 59 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Management Business Unit
|
| 60 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 61 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 62 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates how the employee-paid portion of a benefit plan is paid, either as Cost (C) or Price (P). 'Price' indicates that the benefit is paid from an employee payroll deduction. 'Credit' specifies that the system calculates additional earnings which are used as credit to pay for a benefit.
C=Credit
P=Price
|
| 63 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Type
|
| 64 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 65 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 66 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use tax amount.
|
| 67 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT invoice amount.
|
| 68 |
VAT_NONINV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non invoice amount.
|
| 69 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 70 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver ID Number
|
| 71 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receiver Line Number
|
| 72 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 73 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
|
| 74 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT recovery percent.
|
| 75 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT basis amount.
|
| 76 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT calculated amount.
|
| 77 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT recovery amount.
|
| 78 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non recoverable amount.
|
| 79 |
VAT_DSCNT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount adjustment.
|
| 80 |
VAT_DSCNT_RCVRY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount recovery.
|
| 81 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
VAT code.
|
| 82 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
VAT tax code aggregate percent.
|
| 83 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 84 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 85 |
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)
|
| 86 |
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.
|
| 87 |
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
|
| 88 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit
|
| 89 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 90 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
|
| 91 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
|
| 92 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field
|
| 93 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 94 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 95 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
|
| 96 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field.
|
| 97 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference Chartfield
|
| 98 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield number 1
|
| 99 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 100 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 101 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 102 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate2
|
| 103 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Withholding Flag
|
| 104 |
WTHD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Setid
|
| 105 |
WTHD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Code
|
| 106 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 107 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
|
| 108 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax code - Sales and Use tax.
|
| 109 |
TAX_CD_SUT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sales/Use tax code percent.
|
| 110 |
SALETX_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Amount
|
| 111 |
SUT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Sales Tax Appl, Direct Pay
E=Item is Exempt
S=Sales Tax Appl
U=Use Tax Appl
X=Purchaser is Exonerated
|
| 112 |
VAT_REBATE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT rebate percent.
|
| 113 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT rebate amount.
|
| 114 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicability
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT only
|
| 115 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 116 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT reporting entity.
|
| 117 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 118 |
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.
|
| 119 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 120 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 121 |
MONETARY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Monetary Amount - VCHR BU Base
|
| 122 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 123 |
MERCH_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount in GL Bus Unit Currency
|
| 124 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 125 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 126 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base use tax amount.
|
| 127 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 128 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT invoice amount base.
|
| 129 |
VAT_NONINV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non invoice amount base.
|
| 130 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT recovery amount base.
|
| 131 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non recoverable amount.
|
| 132 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT basis amount in base current.
|
| 133 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT calculated amount base current.
|
| 134 |
VAT_DSCNT_ADJ_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount adjust base.
|
| 135 |
VAT_DSCNT_RCVR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT discount recovery base.
|
| 136 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT rebate amount base.
|
| 137 |
VAT_NR_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non prorated non recoverable VAT base.
|
| 138 |
VAT_NR_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non prorated non recoverable VAT.
|
| 139 |
VAT_NR_AMT_NP_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non prorated non recoverable VAT.
|
| 140 |
USETAX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use tax amount.
|
| 141 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 142 |
USETAX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use tax base amount.
|
| 143 |
MISC_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 144 |
MISC_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 145 |
MEMO_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amount
|
| 146 |
MEMO_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amt Base
|
| 147 |
FREIGHT_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 148 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 149 |
SALETX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 150 |
FREIGHT_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 151 |
SALETX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 152 |
SALETX_CLC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Base Amt
|
| 153 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 154 |
BUDGET_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Line Status
B=Not Subject to Budget Checking
E=Error in Budget Check
N=Not Budget Checked
V=Valid Budget Check
W=Warning in Budget Check
|
| 155 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 156 |
VAT_RCVRY_PCT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT recovey percent source.
A=Automatically calculated
M=Manual Entry
|
| 157 |
VAT_REBATE_PCT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT rebate percent source.
A=Automatically calculated
M=Manual Entry
|
| 158 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount.
|
| 159 |
VAT_TRANS_AMT_GL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount.
|
| 160 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount base currency.
|
| 161 |
VAT_TRANS_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount reporting.
|
| 162 |
CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Reporting Currency
|
| 163 |
VAT_INV_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT amount in reporting currency.
|
| 164 |
VAT_APORT_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit
|
| 165 |
DSCNT_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Prorated Discount Amount
|
| 166 |
DSCNT_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Prorated Base Discount Amount
|
| 167 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|