PeopleSoft 9 Account Payables |
Table Name | BUS_UNIT_OPT_AP |
Table Description |
BUS_UNIT_OPT_AP |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | VARCHAR(5) | Yes | No |
EFFDT | PSDATE | Yes | No |
EFF_STATUS | VARCHAR(1) | No | No |
ACCOUNTING_DT_IND | VARCHAR(1) | No | No |
ACCOUNTING_DT | PSDATE | No | No |
CURRENCY_CD | VARCHAR(3) | No | No |
CUR_RT_TYPE | VARCHAR(5) | No | No |
PYMNT_METHOD | VARCHAR(3) | No | No |
PYMNT_TERMS_CD | VARCHAR(5) | No | No |
PYMNT_TERMS_CD_PPY | VARCHAR(5) | No | No |
DSCNT_ALWAYS_FLG | VARCHAR(1) | No | No |
DSCNT_DELAY_DAYS | SMALLINT | No | No |
PYMNT_DELAY_DAYS | SMALLINT | No | No |
PYMNT_HANDLING_CD | VARCHAR(2) | No | No |
DUP_INVOICE_ACTION | VARCHAR(1) | No | No |
DUP_INV_NUM_FLG | VARCHAR(1) | No | No |
DUP_INV_DT | VARCHAR(1) | No | No |
DUP_INV_VENDOR_NUM | VARCHAR(1) | No | No |
DUP_INV_GROSS_AMT | VARCHAR(1) | No | No |
DUP_INV_BUS_UNIT | VARCHAR(1) | No | No |
DUP_INV_COMB_CODE | SMALLINT | No | No |
GRP_AP_POST_OPT | VARCHAR(1) | No | No |
VCHR_BALANCE_OPT | VARCHAR(1) | No | No |
CHART_EDIT_OPTION | VARCHAR(1) | No | No |
COMBO_EDIT_FLG | VARCHAR(1) | No | No |
BANK_CD | VARCHAR(5) | No | No |
BANK_ACCT_KEY | VARCHAR(4) | No | No |
VCHR_APPRVL_FLG | VARCHAR(1) | No | No |
BUSPROCNAME | VARCHAR(30) | No | No |
APPR_RULE_SET | VARCHAR(30) | No | No |
ROLENAME | VARCHAR(30) | No | No |
SHIPTO_ID | VARCHAR(10) | No | No |
SUT_BASE_ID | VARCHAR(10) | No | No |
SALETX_TOL_FLG | VARCHAR(1) | No | No |
SALETX_TOL_PCT | decimal(5,2) | No | No |
SALETX_TOL_AMT | decimal(26,3) | No | No |
SALETX_TOL_CUR_CD | VARCHAR(3) | No | No |
SALETX_TOL_RT_TYPE | VARCHAR(5) | No | No |
DOC_TYPE | VARCHAR(8) | No | No |
RECEIPT_AWARE | VARCHAR(1) | No | No |
PROCESS_PPV_FLG | VARCHAR(1) | No | No |
PROCESS_ERV_FLG | VARCHAR(1) | No | No |
HOL_PROC_OPT | VARCHAR(1) | No | No |
HOL_PROC_DAYS | SMALLINT | No | No |
HOL_PROC_OVERFL | VARCHAR(1) | No | No |
RECALC_SUT_FLG | VARCHAR(1) | No | No |
TAX_ADJ_DIFF_OPT | VARCHAR(1) | No | No |
TAX_ADJ_LIMIT_OPT | VARCHAR(1) | No | No |
VCHR_TAX_ADJ_DFT | VARCHAR(1) | No | No |
DFT_SIGHT_CD | VARCHAR(5) | No | Yes |
DFT_APPROVE_FLAG | VARCHAR(1) | No | No |
DATE_CALC_BASIS | VARCHAR(1) | No | No |
PAY_SCHEDULE_TYPE | VARCHAR(3) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
PHYSICAL_NATURE | VARCHAR(1) | No | No |
VAT_SVC_PERFRM_FLG | VARCHAR(1) | No | No |
PREPAID_AUTO_APPLY | VARCHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_BUS_UNIT_OPT_AP | PK | Yes |
![]() |
Member(s) of "PS_BUS_UNIT_OPT_AP" Index |
SETID |
EFFDT |
Published June 06, 2007 |