PeopleSoft 9
Account Payables

Table Name BUS_UNIT_TBL_AP

Table Description
BUS_UNIT_TBL_AP
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_NUM_OPTION VARCHAR(1) No No
VCHR_NUM_LAST_USED int No No
GRP_AP_ID_LASTUSED decimal(10) No No
GRP_AP_NUM_OPT VARCHAR(1) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
BU_PSGL_SW VARCHAR(1) No No
POST_OPTION VARCHAR(1) No No
POST_DT_SW VARCHAR(1) No No
POST_THRU_DT PSDATE No No
COMBINE_PYMNT_OPT VARCHAR(1) No No
DB_NUMBER VARCHAR(9) No No
PO_NUM_LAST_USED decimal(10) No No
PO_NUM_OPTION VARCHAR(1) No No
REQ_NUM_LAST_USED decimal(10) No No
REQ_NUM_OPTION VARCHAR(1) No No
DST_CNTRL_ID VARCHAR(10) No No
LOCATION VARCHAR(10) No Yes
POST_UNAPPRV_FLG VARCHAR(1) No No
POST_UNMATCH_FLG VARCHAR(1) No No
CNTRCT_REL_DT_OPT VARCHAR(1) No No
CONTRACT_REL_DT PSDATE No No
REVALUE_OPTION VARCHAR(4) No No
ASSTN_ALG_NAME VARCHAR(15) No No
HOL_PROC_LVL VARCHAR(1) No No
USE_BUS_DAY_FLG VARCHAR(1) No No
GO_NXT_PRV_FLG VARCHAR(1) No No
HOLIDAY_LIST_ID VARCHAR(10) No No
HIDE_SUT_FLG VARCHAR(1) No No
HIDE_VAT_FLG VARCHAR(1) No No
VCHR_SUT_MSG_OPT VARCHAR(1) No No
VCHR_VAT_MSG_OPT VARCHAR(1) No No
SBI_DOC_DFLT VARCHAR(1) No No
ERS_OPT_DFLT VARCHAR(1) No No
ERS_INV_DT_DFLT VARCHAR(1) No No
ERS_TAX_TYPE_DFLT VARCHAR(1) No No
VCHR_MTCH_ADJ_OPT VARCHAR(1) No No
VCHR_TAX_ADJ_OPT VARCHAR(1) No No
TAX_ADJ_LIMIT_OPT VARCHAR(1) No No
TAX_ADJ_DIFF_OPT VARCHAR(1) No No
RTV_VCHR_ADJ_OPT VARCHAR(1) No No
RTV_DEBIT_MEMO VARCHAR(1) No No
VCHR_BLD_DEFN VARCHAR(10) No No
RECEIPT_DELAY_DAYS SMALLINT No No
MTCH_ADJ_DELAY_DAY SMALLINT No No
PAY_TRM_BSE_DT_OPT VARCHAR(1) No No
CUR_EXC_DT_SRC_DFT VARCHAR(1) No No
SHIPTO_ID VARCHAR(10) No No
COPYTO_GROSS_AMT VARCHAR(1) No No
EARLY_PY_RSN_CD VARCHAR(4) No No
TSYMBOL_ATTRIB VARCHAR(16) No No
LATE_PY_RSN_CD VARCHAR(4) No No
LATE_CHRG_OPT VARCHAR(1) No No
LATE_CHRG_CD VARCHAR(4) No No
APPL_CREDIT_OPT VARCHAR(1) No No
REAL_TIME_POST VARCHAR(1) No No
POST_TO_GL_FLG VARCHAR(1) No No
POST_PREPAID_FLG VARCHAR(1) No No
GFEE_RUN_EEG VARCHAR(1) No No
LARGE_VCHR_DEFN int No No
PROCESS_LINES_FLAG VARCHAR(1) No No
TAX_VENDOR VARCHAR(1) No No
TAX_COMPANY VARCHAR(5) No No
TAX_DIVISION VARCHAR(5) No No
ULTIMATE_USE_CD VARCHAR(8) No No
INCLUDE_FREIGHT VARCHAR(1) No No
FRGHT_PRODUCT_CD VARCHAR(18) No No
TAX_POST_OPTION VARCHAR(1) No No
FREIGHT_TERMS VARCHAR(10) No No
SHIP_TYPE_ID VARCHAR(10) No No
MATCH_APPRV_FLG VARCHAR(1) No No
SUMM_TOL_PCT_OVER DECIMAL(5,2) No No
SUMM_TOL_PCT_UNDER DECIMAL(5,2) No No
SUMM_TOL_AMT_OVER DECIMAL(26,3) No No
SUMM_TOL_AMT_UNDER DECIMAL(26,3) No No
SUMM_TOL_CUR_CD VARCHAR(3) No No
SUMM_TOL_RT_TYPE VARCHAR(5) No No
SUMM_TOL_MISC_CHG VARCHAR(10) No No
MATCH_DELAY_DAYS SMALLINT No No
Index
Name Type Unique Member
PS_BUS_UNIT_TBL_AP PK Yes
Member(s) of "PS_BUS_UNIT_TBL_AP" Index
BUSINESS_UNIT

Published June 06, 2007