UPG_ACCTLN_TMP (SQL Table)	Index Back
AP Accting Lilne Upgrade table

UPG_ACCTLN_TMP

(SQL Table)

AP Accting Lilne Upgrade table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

2 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

3 POSTING_PROCESS Character(4) VARCHAR2(4) NOT NULL Posting Process
ACAV=Period End Accruals
ACCR=AP Accrual
CANC=Payment Cancelations
CASH=Cash Clearing
CLOS=Voucher Closure
DFTA=Draft Accrual
PCAD=Card
PPAY=Prepaid Reversals
PREP=Prepaids
PYMN=Payments
RACC=Receipt Accrual
RCVL=Revaluation
REVL=Revaluations
VOID=Void
WTHA=Withholding Accrual

4 COMPLETED_FLG Character(1) VARCHAR2(1) NOT NULL Completed
N=Not Completed
Y=Complete
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
2	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
3	POSTING_PROCESS	Character(4)	VARCHAR2(4) NOT NULL	Posting Process ACAV=Period End Accruals ACCR=AP Accrual CANC=Payment Cancelations CASH=Cash Clearing CLOS=Voucher Closure DFTA=Draft Accrual PCAD=Card PPAY=Prepaid Reversals PREP=Prepaids PYMN=Payments RACC=Receipt Accrual RCVL=Revaluation REVL=Revaluations VOID=Void WTHA=Withholding Accrual
4	COMPLETED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Completed N=Not Completed Y=Complete Y/N Table Edit Default Value: N