BUS_UNIT_SF_AP

(SQL Table)
Index Back

AP Business Unit Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor Set ID

Prompt Table: SF_AP_VNDR_OPTN

5 AP_VOUCHER_SEQ_BY Character(1) VARCHAR2(1) NOT NULL Voucher Sequencing By
A=Automatic Sequencing
R=Use SF Refund# as Voucher#

Default Value: A

6 AP_PREFIX_SF Character(2) VARCHAR2(2) NOT NULL Ap Prefix
7 VCHR_NUM_LAST_USED Number(8,0) INTEGER NOT NULL Last Voucher Number
8 SF_AP_ORIGIN Character(3) VARCHAR2(3) NOT NULL Voucher Origin
9 SF_AP_OPRID Character(8) VARCHAR2(8) NOT NULL AP User ID
10 GRP_AP_NUM_OPT Character(1) VARCHAR2(1) NOT NULL Control Group Numbering

Y/N Table Edit

Default Value: N

11 GRP_AP_ID_LASTUSED Number(10,0) DECIMAL(10) NOT NULL Group ID Last Used
12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

Prompt Table: SP_BU_GL_NONVW

13 POST_OPTION Character(1) VARCHAR2(1) NOT NULL Posting Option

Y/N Table Edit

Default Value: Y

14 POST_THRU_DT Date(10) DATE Post Thru Date
15 DB_NUMBER Number(9,0) DECIMAL(9) NOT NULL D+B Number
16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: HCR_LOCATION_I

17 SSF_CHK_VNDR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier to be used for Check processing.
18 SSF_DIRDEP_VNDR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier for Direct Deposit processing
19 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID
03=CHIPS ID
04=Canadian Bank Branch/Institute
ZZ=Mutually Defined