PeopleSoft 9
Account Payables

Table Name ORIGIN_AP_OPT

Table Description
ORIGIN_AP_OPT
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
ORIGIN VARCHAR(3) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
POST_OPTION 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
DUP_INVOICE_IND VARCHAR(1) 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
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) 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
PYMNT_TERMS_CD VARCHAR(5) No No
PYMNT_HANDLING_CD VARCHAR(2) No No
DST_CNTRL_ID VARCHAR(10) No No
VCHR_APPRVL_FLG VARCHAR(1) No No
BUSPROCNAME VARCHAR(30) No No
APPR_RULE_SET VARCHAR(30) No No
SHIPTO_ID VARCHAR(10) No No
SUT_BASE_ID VARCHAR(10) No No
SHIP_LOC_FLG VARCHAR(1) 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
DOC_TYPE_FLG VARCHAR(1) No No
DFT_SIGHT_CD VARCHAR(5) No No
DATE_CALC_BASIS VARCHAR(1) No No
PAY_SCHEDULE_TYPE VARCHAR(3) No No
LATE_CHRG_FLG VARCHAR(1) No No
LATE_CHRG_OPT VARCHAR(1) No No
LATE_CHRG_CD VARCHAR(4) No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
ULTIMATE_USE_CD VARCHAR(8) No No
ULT_USE_CD_FLG VARCHAR(1) No No
MATCH_DELAY_FLG VARCHAR(1) No No
MATCH_DELAY_DAYS SMALLINT No No
Index
Name Type Unique Member
PS_ORIGIN_AP_OPT PK Yes
Member(s) of "PS_ORIGIN_AP_OPT" Index
SETID
ORIGIN
EFFDT

Published June 06, 2007