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 |