UPG_EG702_DSTLN

(SQL Table)
Index Back

Voucher Distribution Table

  • Parent record: VOUCHER_LINE
  • # 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

    Default Value: 1

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

    Default Value: 1

    5 SUSPENSE_REF_NUM Number(5,0) INTEGER NOT NULL Suspense Reference Number
    6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BUPRCR_NONVW

    7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT

    8 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    9 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.
    10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    11 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.
    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 Amount
    18 VAT_DSCNT_ADJ_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
    19 VAT_DSCNT_RCVR_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
    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 Amt Base Sum
    23 VAT_NRCVR_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
    24 VAT_REBATE_AMT_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt Base Sum
    25 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.
    26 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    27 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.

    Prompt Table: %RECNAME_EDIT

    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 F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    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 The accounting entry construction date for a given transaction (a generic field that crosses multiple
    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: 11/24/08 - Added TARGET label [PC product]
    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 PC Business Unit

    Prompt Table: %EDIT_BU_PC

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

    Prompt Table: %EDIT_ACTIVITY

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

    Prompt Table: %EDIT_ANALYSIS

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

    Prompt Table: %EDIT_RESOURCE

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

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

    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 Interunit excahnge 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 AM Business Unit

    Prompt Table: %EDITTABLE5

    60 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: %EDITTABLE6

    61 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: %EDITTABLE7

    62 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

    Prompt Table: %EDITTABLE18

    63 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.

    Prompt Table: VAT_TXN_CD

    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 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 number
    71 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    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 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.
    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 Amt
    78 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
    79 VAT_DSCNT_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj
    80 VAT_DSCNT_RCVRY Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj Rcvr
    81 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.
    82 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.
    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 ChartField

    Prompt Table: OPERUNT_BUGL_VW

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

    Prompt Table: PRODUCT_BUGL_VW

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

    Prompt Table: FUND_BUGL_VW

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

    Prompt Table: CLASSCF_BUGL_VW

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

    Prompt Table: PROGRAM_BUGL_VW

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

    Prompt Table: BUD_REF_BUGL_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_BUGL_VW

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

    Prompt Table: CF2_BUGL_VW

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

    Prompt Table: CF3_BUGL_VW

    100 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    101 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: %EDIT_ALTACCT
    Set Control Field: ALTACCT_SETID

    102 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW
    Set Control Field: ALTACCT_SETID

    103 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099
    104 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
    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(8,4) DECIMAL(7,4) 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=Direct Pay
    E=Item is Exempt
    S=Sales Tax Applicable
    U=Use Tax Applicable
    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 Amt
    114 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
    115 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
    116 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.
    117 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. "
    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 Amt Base Curr
    129 VAT_NONINV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amt Base Curr
    130 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
    131 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
    132 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
    133 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
    134 VAT_DSCNT_ADJ_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
    135 VAT_DSCNT_RCVR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
    136 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
    137 VAT_NR_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
    138 VAT_NR_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
    139 VAT_NR_AMT_NP_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Prorated Non Recover VAT
    140 USETAX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Base 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 Base Use Tax Amount
    143 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.
    144 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
    145 MISC_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
    146 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.
    147 MEMO_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Memo Amount
    148 MEMO_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Memo Amt Base
    149 FREIGHT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    150 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
    151 SALETX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
    152 FREIGHT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
    153 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.
    154 SALETX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
    155 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.
    156 SALETX_CLC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated Sales Tax Base Amt
    157 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    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
    159 BUDGET_DT Date(10) DATE Budget Date
    160 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
    A=Automatically calculated
    M=Manual Entry
    161 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
    A=Automatically calculated
    M=Manual Entry
    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_GL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
    164 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
    165 VAT_TRANS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Transaction Amt Reporting
    166 CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Reporting Currency
    167 VAT_INV_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amt in Reporting Currency
    168 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
    169 DSCNT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL DiscountAmount
    170 DSCNT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL NonproratedDiscountAmount
    171 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.
    172 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
    173 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    175 VAT_LN_ENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Line Entered Amount
    176 VAT_LN_ENT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Line Entered Amt Base Curr
    177 VAT_MBASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Basis Amount
    178 VAT_MBASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Basis Amt Base Curr
    179 VAT_MTRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Transaction Amount
    180 VAT_MTRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Memo Trans Amt Base Curr
    181 USER_VCHR_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
    182 USER_VCHR_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field 2
    183 USER_VCHR_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field
    184 USER_VCHR_DATE Date(10) DATE User Date
    185 USER_VCHR_NUM1 Number(3,0) SMALLINT NOT NULL User Number field
    186 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

    187 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    188 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    189 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    190 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    191 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    192 CUSTOM_DATE_D Date(10) DATE Custom Date
    193 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    194 UPG_BUDGET_YEAR Character(4) VARCHAR2(4) NOT NULL Budget Year
    195 MONETARY_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base
    196 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
    197 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key