Populating VCHR_DIST_STG
This topic discusses how to use the proposed PeopleSoft Billing approach for populating the VCHR_DIST_STG table.
|
Field Name |
How Billing Populates |
|---|---|
|
BUSINESS_UNIT |
BUS_UNIT_TBL_GL.BUSINESS_UNIT_AP when the InterUnit method is defined as direct or indirect. IU_INTER_PR_TR.BUSINESS_UNIT_AP when the InterUnit method is defined as pair. |
|
VCHR_BLD_KEY_C1 |
Billing BU |
|
VCHR_BLD_KEY_C2 |
Invoice Number |
|
VCHR_BLD_KEY_N1 |
Dependent on AP_LVL setting if header level = 0, if line level = line_seq_num |
|
VCHR_BLD_KEY_N2 |
0 |
|
ECTRANSID |
BI-VCHR-IN |
|
VOUCHER_ID |
NEXT |
|
VOUCHER_LINE_NUM |
BI_LINE_IU_EXP.LINE_SEQ_NUM |
|
DISTRIB_LINE_NUM |
BI_LINE_IU_EXP.LINE_DIST_SEQ_NUM |
|
ACCOUNT |
BI_LINE_IU_EXP.ACCOUNT |
|
STATISTICS_CODE |
BI_LINE_IU_EXP.STATISTICS_CODE |
|
QTY_VCHR |
0 |
|
STATISTICS_AMOUNT |
0 |
|
JRNL_LN_REF |
Blank |
|
DESCR |
Blank |
|
MERCHANDISE_AMT |
BI_LINE.AMOUNT |
|
BUSINESS_UNIT_GL |
Blank |
|
BUSINESS_UNIT_PO |
Blank |
|
PO_ID |
Blank |
|
LEASE_PYMNT_DT |
Null |
|
LINE_NBR |
0 |
|
SCHED_NBR |
0 |
|
PO_DIST_LINE_NUM |
0 |
|
BUSINESS_UNIT_PC |
Blank |
|
ACTIVITY_ID |
Blank |
|
ANALYSIS_TYPE |
Blank |
|
RESOURCE_TYPE |
Blank |
|
RESOURCE_CATEGORY |
Blank |
|
RESOURCE_SUB_CAT |
Blank |
|
ASSET_FLG |
Y if BI_LINE.BUSINESS_UNIT_AMTO does not equal blank. Else, blank. |
|
BUSINESS_UNIT_AM |
BI_LINE.BUSINESS_UNIT_AMTO |
|
ASSET_ID |
BI_LINE.ASSET_ID |
|
COST_TYPE |
BI_LINE.COST_TYPE |
|
PROFILE_ID |
BI_LINE.PROFILE_ID |
|
VAT_TXN_TYPE_CD |
Blank |
|
BUSINESS_UNIT_RECV |
Blank |
|
RECEIVER_ID |
Blank |
|
RECV_LN_NBR |
0 |
|
RECV_SHIP_SEQ_NUM |
0 |
|
RECV_DIST_LINE_NUM |
0 |
|
DEPTID |
BI_LINE_IU_EXP.DEPTID |
|
PROJECT_ID |
BI_LINE_IU_EXP.PROJECT_ID |
|
ALTACCT |
BI_LINE_IU_EXP.ALTACCT |
|
CF12_AN_SBR |
BI_LINE_IU_EXP.CF12_AN_SBR |
|
BUDGET_DT |
Null |
|
ENTRY_EVENT |
Blank |
|
VAT_APORT_CNTRL |
Blank |
|
VCHRD_USER_SBR |
USER_VCHR_CHAR1 = blank USER_VCHR_CHAR2 = blank USER_VCHR_DEC = 0 USER_VCHR_DATE = null USER_VCHR_NUM1 = 0 |
|
PUR_USR_DST_SBR |
USER_DIST_CHAR1 = blank |
|
OPEN_ITEM_KEY |
Blank |
|
VAT_RECOVERY_PCT |
0 |
|
VAT_REBATE_PCT |
0 |
|
VAT_CALC_AMT |
0 |
|
VAT_BASIS_AMT |
0 |
|
VAT_RCVRY_AMT |
0 |
|
VAT_NRCVR_AMT |
0 |
|
VAT_REBATE_AMT |
0 |
|
VAT_TRANS_AMT |
0 |
|
TAX_CD_VAT_PCT |
0 |
|
VAT_INV_AMT |
0 |
|
VAT_NONINV_AMT |
0 |
|
WO_ID |
Blank |
|
WO_TASK_ID |
0 |
|
RSRC_TYPE |
Blank |
|
RES_LN_NBR |
0 |
|
ECQUEUEINSTANCE |
0 |