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
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(6,0) INTEGER 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