| BUS_UNIT_SF_AP(SQL Table) | Index Back | 
|---|---|
| AP Business Unit Definition | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 |