SSF_VCHDIST_STG

(SQL Table)
Index Back

EC Voucher Distrib Line

Voucher distrib line Staging record.This is used for processing Single Payment Voucher data for integration with AP.

  • Parent record: VCHR_LINE_STG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 VCHR_BLD_KEY_C1 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1
    4 VCHR_BLD_KEY_C2 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1
    5 VCHR_BLD_KEY_N1 Number(10,0) DECIMAL(10) NOT NULL Voucher Build Key Num 1
    6 VCHR_BLD_KEY_N2 Number(10,0) DECIMAL(10) NOT NULL Vchr Build Key Num 2
    7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    8 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    9 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line Number
    10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
    11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    14 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
    15 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Statistic Amount
    16 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt
    19 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    20 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    21 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number
    22 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    23 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    24 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    25 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    26 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    27 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type
    28 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    29 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    30 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
    31 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL Asset Management Business Unit
    32 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    33 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    34 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
    35 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL VAT Transaction Type
    36 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    37 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver ID Number
    38 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receiver Line Number
    39 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    40 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
    41 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    42 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    43 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    44 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    45 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    46 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    47 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    48 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    49 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    50 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    51 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    52 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    53 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    54 BUDGET_DT Date(10) DATE Budget Date
    55 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
    56 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.
    57 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)
    58 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Journal Line Reference
    59 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
    D=Distribution GL Business Unit
    60 USER_VCHR_CHAR1 Character(1) VARCHAR2(1) NOT NULL User Character Field
    61 USER_VCHR_CHAR2 Character(1) VARCHAR2(1) NOT NULL User Character Field 2
    62 USER_VCHR_DEC Signed Number(28,3) DECIMAL(26,3) NOT NULL User Amount Field
    63 USER_VCHR_DATE Date(10) DATE User Date
    64 USER_VCHR_NUM1 Number(3,0) SMALLINT NOT NULL User Number field
    65 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Distribution User Field
    66 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
    67 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT recovery percent.
    68 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT rebate percent.
    69 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT calculated amount.
    70 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT basis amount.
    71 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT recovery amount.
    72 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT non recoverable amount.
    73 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT rebate amount.
    74 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT transaction amount.
    75 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL VAT tax code aggregate percent.
    76 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT invoice amount.
    77 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT non invoice amount.
    78 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    79 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
    80 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
    81 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Resource Type: Member Org or Initiative.
    I=Initiative
    M=Member Organization
    82 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.