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