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