APIPAC_VCHRLINE

(SQL View)
 Index Back

Voucher Line

Voucher Line

SELECT A.BUSINESS_UNIT , B.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.TOTAL_DISTRIBS , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DESCR , A.DESCR254_MIXED , SUM (C.IPAC_LN_AMT ) , A.ITM_SETID , A.INV_ITEM_ID , A.STATISTIC_AMOUNT , A.DSCNT_APPL_FLG , B.PROCESS_INSTANCE , A.WTHD_SW , A.TAX_CD_VAT , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , 'N' , 'Q' , A.VAT_TXN_TYPE_CD , A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.SHIPTO_ID , A.SUT_BASE_ID , A.TAX_CD_SUT , A.ULTIMATE_USE_CD , A.SUT_EXCPTN_TYPE , A.SUT_EXCPTN_CERTIF , A.SUT_APPLICABILITY , A.WTHD_CD , A.VAT_APPLICABILITY , A.VAT_USE_ID , A.BUSINESS_UNIT_RTV , A.RTV_ID , A.RTV_LN_NBR , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.RELEASE_NBR , A.VERSION_NBR , A.CAT_LINE_NBR , B.BUSINESS_UNIT , B.VOUCHER_ID_RELATED , A.VENDOR_ID , A.SPEEDCHART_KEY , A.RECEIPT_DT , A.INSPECT_DT , A.VAT_LN_ENT_AMT , %subrec(VCHRL_USER_SBR, A) , A.VNDR_LOC , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) , A.TAX_DSCNT_FLG , A.TAX_FRGHT_FLG , A.TAX_MISC_FLG , A.TAX_VAT_FLG , A.EXS_TAX_TXN_TYPE , A.CATEGORY_ID , A.TITLE_PASSAGE , A.TAX_JOB_NUM , A.TAX_USER_AREA , A.SUT_PRODUCT_CD , A.SUT_FREIGHT_CD , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.REQUESTOR_ID , A.VAT_TREATMENT , A.VAT_RCRD_INPT_FLG , A.VAT_RCRD_OUTPT_FLG , A.IST_TXN_FLG , A.PHYSICAL_NATURE , A.COUNTRY_LOC_BUYER , A.STATE_LOC_BUYER , A.COUNTRY_LOC_SELLER , A.STATE_LOC_SELLER , A.VAT_SVC_SUPPLY_FLG , A.VAT_SERVICE_TYPE , A.COUNTRY_VAT_PERFRM , A.STATE_VAT_PERFRM , A.COUNTRY_VAT_SUPPLY , A.STATE_VAT_SUPPLY , A.STATE_SHIP_FROM , A.STATE_VAT_DEFAULT , A.VAT_RECEIPT , A.VAT_RGSTRN_SELLER , A.TRANS_DT , A.VAT_RVRSE_CHG_GDS , A.PACKSLIP_NO , A.BUSINESS_UNIT_BI , A.BI_INVOICE , A.LINE_SEQ_NUM , %subrec(VCHR_PO_GRP_SBR, A) , SUM(C.IPAC_QUANTITY) , MIN(C. UNIT_OF_ISSUE) , %DecMult (MIN(C.IPAC_UNIT_PRICE),-1) FROM PS_VOUCHER_LINE A , PS_AP_IPAC_HDR B , PS_AP_IPAC_DETAIL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID_RELATED AND B.VOUCHER_ID = C.VOUCHER_ID AND B.IPAC_HDR_SEQ_NUM = C.IPAC_HDR_SEQ_NUM AND A.VOUCHER_LINE_NUM = C.IPAC_ORIG_LN_ITM GROUP BY A.BUSINESS_UNIT , B.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.TOTAL_DISTRIBS , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DESCR , A.DESCR254_MIXED , A.ITM_SETID , A.INV_ITEM_ID , A.STATISTIC_AMOUNT , A.DSCNT_APPL_FLG , B.PROCESS_INSTANCE , A.WTHD_SW , A.TAX_CD_VAT , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.VAT_TXN_TYPE_CD , A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.SHIPTO_ID , A.SUT_BASE_ID , A.TAX_CD_SUT , A.ULTIMATE_USE_CD , A.SUT_EXCPTN_TYPE , A.SUT_EXCPTN_CERTIF , A.SUT_APPLICABILITY , A.WTHD_CD , A.VAT_APPLICABILITY , A.VAT_USE_ID , A.BUSINESS_UNIT_RTV , A.RTV_ID , A.RTV_LN_NBR , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.RELEASE_NBR , A.VERSION_NBR , A.CAT_LINE_NBR , B.BUSINESS_UNIT , B.VOUCHER_ID_RELATED , A.VENDOR_ID , A.SPEEDCHART_KEY , A.RECEIPT_DT , A.INSPECT_DT , A.VAT_LN_ENT_AMT , %subrec(VCHRL_USER_SBR, A) , A.VNDR_LOC , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) , A.TAX_DSCNT_FLG , A.TAX_FRGHT_FLG , A.TAX_MISC_FLG , A.TAX_VAT_FLG , A.EXS_TAX_TXN_TYPE , A.CATEGORY_ID , A.TITLE_PASSAGE , A.TAX_JOB_NUM , A.TAX_USER_AREA , A.SUT_PRODUCT_CD , A.SUT_FREIGHT_CD , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.REQUESTOR_ID , A.VAT_TREATMENT , A.VAT_RCRD_INPT_FLG , A.VAT_RCRD_OUTPT_FLG , A.IST_TXN_FLG , A.PHYSICAL_NATURE , A.COUNTRY_LOC_BUYER , A.STATE_LOC_BUYER , A.COUNTRY_LOC_SELLER , A.STATE_LOC_SELLER , A.VAT_SVC_SUPPLY_FLG , A.VAT_SERVICE_TYPE , A.COUNTRY_VAT_PERFRM , A.STATE_VAT_PERFRM , A.COUNTRY_VAT_SUPPLY , A.STATE_VAT_SUPPLY , A.STATE_SHIP_FROM , A.STATE_VAT_DEFAULT , A.VAT_RECEIPT , A.VAT_RGSTRN_SELLER , A.TRANS_DT , A.VAT_RVRSE_CHG_GDS , A.PACKSLIP_NO , A.BUSINESS_UNIT_BI , A.BI_INVOICE , A.LINE_SEQ_NUM , %subrec(VCHR_PO_GRP_SBR, A)

  • Parent record: VOUCHER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VOUCHER

    3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

    Default Value: 1

    4 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
    5 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Prompt Table: SP_BUS_PM_NONVW

    6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: %EDITTABLE14

    7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Prompt Table: %EDITTABLE15

    8 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

    Prompt Table: %EDITTABLE16

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    11 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE13
    Set Control Field: ITM_SETID

    14 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.
    15 DSCNT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Discount

    Y/N Table Edit

    Default Value: Y

    16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    17 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Y/N Table Edit

    Default Value: VENDOR.WTHD_SW

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

    Prompt Table: VAT_HEADER_VW

    19 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

    Prompt Table: SP_BUS_PM_NONVW

    20 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Prompt Table: %EDITTABLE12

    21 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

    Prompt Table: %EDITTABLE8

    22 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

    Prompt Table: %EDITTABLE9

    23 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
    E=ERS
    F=Full Match
    N=Don't Match

    Default Value: N

    24 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
    A=Amount
    Q=Quantity

    Default Value: A

    25 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

    26 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)
    27 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.
    28 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
    29 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

    Prompt Table: VCHR_SHIPTO_DVW

    30 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

    Prompt Table: VCHR_SHIPTO_DVW

    31 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

    Prompt Table: TAX_SALE_VW

    32 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code

    Prompt Table: SUT_USE_CD

    33 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
    D=Direct Pay
    E=Exempt/Exonerated
    N=None
    34 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
    35 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

    Default Value: E

    36 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code

    Prompt Table: WTHD_CD_HDR

    37 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
    38 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

    Prompt Table: VAT_USE_TBL

    39 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
    40 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
    41 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
    42 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    43 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
    44 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    45 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Default Value: 1

    46 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
    47 BUS_UNIT_RELATED Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    48 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
    49 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    50 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key
    51 RECEIPT_DT Date(10) DATE Received Date
    52 INSPECT_DT Date(10) DATE Inspection Date
    53 VAT_LN_ENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Line Entered Amount
    54 USER_VCHR_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
    55 USER_VCHR_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field 2
    56 USER_VCHR_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field
    57 USER_VCHR_DATE Date(10) DATE User Date
    58 USER_VCHR_NUM1 Number(3,0) SMALLINT NOT NULL User Number field
    59 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    60 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    61 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    62 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    63 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    64 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    65 CUSTOM_DATE_B Date(10) DATE Custom Date
    66 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    67 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    68 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    69 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    70 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    71 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
    72 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
    73 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    74 TAX_DSCNT_FLG Character(1) VARCHAR2(1) NOT NULL Include Discount

    Y/N Table Edit

    Default Value: N

    75 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight

    Y/N Table Edit

    Default Value: N

    76 TAX_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Misc Charges

    Y/N Table Edit

    Default Value: N

    77 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    78 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
    DEB=Direct Export With Bond
    DEWB=Direct Export Without Bond
    DIMP=Direct Import
    DOM=Domestic
    LEB=Local Export With Bond
    LEWB=Local Export Without Bond
    LIMP=Local Import
    79 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    80 TITLE_PASSAGE Character(1) VARCHAR2(1) NOT NULL Title Passage
    B=Buyer's Destination-Ship To
    I=Intermediate Consignee
    S=Seller's Origination-Ship From
    81 TAX_JOB_NUM Character(10) VARCHAR2(10) NOT NULL Job Number
    82 TAX_USER_AREA Character(25) VARCHAR2(25) NOT NULL Used for tax calculation by tax vendor.
    83 SUT_PRODUCT_CD Character(18) VARCHAR2(18) NOT NULL Product Alias
    84 SUT_FREIGHT_CD Character(18) VARCHAR2(18) NOT NULL Product Alias
    85 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    86 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    87 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    88 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
    89 VAT_RCRD_INPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.

    Y/N Table Edit

    90 VAT_RCRD_OUTPT_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.

    Y/N Table Edit

    91 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
    N=No
    Y=Yes
    92 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    93 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
    94 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
    95 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner
    96 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner
    97 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
    98 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
    1=Freight Transport
    2=Other
    3=Electronics/Communication
    99 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
    100 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed
    101 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
    102 STATE_VAT_SUPPLY Character(6) VARCHAR2(6) NOT NULL VAT Place of Supply State
    103 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
    104 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
    105 VAT_RECEIPT Character(1) VARCHAR2(1) NOT NULL No VAT Receipt

    Y/N Table Edit

    Default Value: Y

    106 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
    107 TRANS_DT Date(10) DATE Transaction Date
    108 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag
    109 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
    110 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    111 BI_INVOICE Character(22) VARCHAR2(22) NOT NULL Billing Invoice number
    112 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    113 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    114 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
    N=No
    Y=Yes
    115 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
    116 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
    117 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    118 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    119 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price