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 |