SSF_VCHDIST_STG(SQL Table) |
Index Back |
---|---|
EC Voucher Distrib LineVoucher distrib line Staging record.This is used for processing Single Payment Voucher data for integration with AP. |
# | 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. |