Accounts Payable Tables
=======================
---------------------------------------------------------------------
stp1099r Accounts Payable 1099 Reference
vend_code char(20), vendor code
total_amt decimal(12), total cash disbursed to vendor
cat_1_amt decimal(12), category 1 amount
cat_2_amt decimal(12), category 2 amount
cat_3_amt decimal(12), category 3 amount
cat_4_amt decimal(12), category 4 amount
cat_5_amt decimal(12), category 5 amount
cat_6_amt decimal(12), category 6 amount
cat_7_amt decimal(12), category 7 amount
cat_8_amt decimal(12), category 8 amount
cat_9_amt decimal(12), category 9 amount
cat_10_amt decimal(12), category 10 amount
cat_11_amt decimal(12), category 11 amount
cat_12_amt decimal(12), category 12 amount
cat_13_amt decimal(12), category 13 amount
cat_14_amt decimal(12), category 14 amount
cat_15_amt decimal(12) category 15 amount
-------------------------------------------------------------------
stpactvd Accounts Payable Activity Detail Table
orig_journal char(2) not null original journal
doc_no integer not null document number
act_type char(1), activity type
inv_doc_no integer, invoice doc # that is affected
amount decimal(12), transaction amount
currency_code char(3), currency code
curr_ex_rate decimal(16), currency exchange rate
home_curr_amount decimal(12) home currency amount
------------------------------------------------------------------
stpactvv Accounts Payable Document Activity View
orig_journal(2),not null original journal
doc_no integer,not null document number
post_no integer post number
post_date date post date
doc_date date,not null post date
ref_code(20) reference code
doc_desc(30) document description
inv_chk_no (10) invoice check number
doc_type (2) document type
act_type (1) activity type
inv_doc_no integer invoice document number
amount (12) transaction amount
-----------------------------------------------------------------
stpcashd Cash Disbursement Entry Detail
doc_no integer, document number
inv_doc_no integer, invoice doc# to affect
inv_no char(20), invoice number
due_date date, invoice due date
dist_acct integer, ap distribution account number
dist_department char(3), ap distribution department
dist_amt decimal(12), ap distribution amount
dist_deb_cred char(2), ap distribution debit/credit
mtax_code char(6), multi-tax code
goods_amt decimal(12), goods amount
disc_acct integer, discount account number
disc_department char(3), discount department
disc_amt decimal(12), discount amount
disc_deb_cred char(2) discount debit/credit
-----------------------------------------------------------------
stpcashe Cash Disbursement Entry Header
chk_date date, check date
doc_no serial not null, document number
vend_code char(20), vendor code
pay_to_code char(6), vendor pay-to code
gross_entry char(1), gross amount entry
def_mtaxcd char(6), default multilevel tax code
check_no char(10), check number
doc_desc char(30), document description
cash_amt decimal(12), cash amount
cash_acct integer, cash account number
cash_department char(3), cash account department
cash_deb_cred char(2), cash debit/credit
oa_amt decimal(12), amount to apply on account
oa_acct integer, on account account number
oa_department char(3), on account department number
oa_deb_cred char(2), on account debit/credit
print_chk char(1), print check y/n
ok_to_post char(1), okay to post
chk_printed char(1), check has been printed
ap_type char(1), ap type
batch_id integer, batch id
orig_journal char(2), originating journal
trans_doc_no integer,
posted char(1))
index i3stpcashe on stpcashe(orig_journal, trans_doc_no)
----------------------------------------------------------------
stpcntrc Accounts Payable Control Table
terms_code char(6), default terms code
ap_acct_no integer, default ap account number
cd_cash_acct_no integer, default cash account number
cd_disc_acct_no integer, default discount account number
ap_doc_no integer, last ap doc #
ap_post_no integer, last ap posting batch number
ap_balanced char(1), ap setup complete?
cd_doc_no integer, last cash disbursement doc #
cd_post_no integer, last cash disbursement post #
age_datetype char(1), aging based on (inv or due date)
age_per1 smallint, number of days in aging period 1
age_per2 smallint, number of days in aging period 2
age_per3 smallint, number of days in aging period 3
age_dsc1 char(15), aging period 1 description
age_dsc2 char(15), aging period 2 description
age_dsc3 char(15), aging period 3 description
age_dsc4 char(15), aging period 4 description
federal_tax_id char(10), federal tax id number
dflt_1099 char(1), default vendor 1099 reporting
def_mtaxcd char(6), default multilevel tax code
gross_entry char(1), gross invoice entry
mtax_dsc char(1), multilevel tax code on discounts
entry_by_line char(1), tax entry on detail line
disc_frght char(1), discount on freight
disc_tax char(1), discount on tax
use_batch_inv char(1), use bath on invoices
use_batch_pay char(1), use batch on payments
use_approv_post char(1), need approval to post
approval_code char(8) posting approval code
----------------------------------------------------------------
stpinvcd Accounts Payable Invoice Detail Entry Table
doc_no integer not null, document number
line_no smallint, line number
acct_no integer, account number
department char(3), department number
amount decimal(12), amount
debit_credit char(2), debit/credit
mtax_code char(6), multilevel tax code
goods_amt decimal(12) goods amount
---------------------------------------------------------------
stpinvce Accounts Payable Invoice Entry Header Table
doc_no serial not null, document number
inv_no char(20), invoice number
department char(3), default department
file_type char(1), file type(inv,debit,credit)
ref_no integer, inv doc# affected by DB/CR
inv_desc char(30), document description
doc_date date, document date
vend_code char(20), vendor code
pay_to_code char(6), vendor payto code
posted char(1), only recurring inv marked y/n
recurring char(1), marked for recurring y/n
terms_code char(6), payment terms code
inv_date date, invoice date
to_pay_date date, date to pay invoice
due_date date, invoice due date
disc_date date, date discount must be taken by
disc_pct decimal(6), discount percent
po_date date, purchase order date
po_no char(10), purchase order number
disc_acct_no integer, discount account number
disc_department char(3), discount department
disc_amount decimal(12), discount amount
disc_debit_credit char(2), discount debit/credit
ap_acct_no integer, ap account number
ap_department char(3), ap department number
ap_amount decimal(12), ap amount
ap_debit_credit char(2), ap debit/credit
ok_to_post char(1), okay to post
cash_acct_no integer, cash account number
cash_department char(3), cash account department
recurr_ref char(10), recurring reference number
def_mtaxcd char(6), default multilevel tax code
gross_entry char(1), use gross entry
currency_code char(3), multicurrency code
curr_ex_rate decimal(16), multicurrency exchange rate
home_curr_amount decimal(12),home currency amount
fix_date_flag char(1), fix dates flag
batch_id integer, batch id
recurr_cnt integer, recurring count
orig_journal char(2), originating journal
trans_doc_no integer document number of the transaction
index i2stpinvce on stpinvce(orig_journal, trans_doc_no)
----------------------------------------------------------------
stpopend Accounts Payable Open Item Table
vend_code char(20), vendor code
pay_to_code char(6), vendor payto code
inv_no char(20), invoice number
doc_no integer, document number
inv_desc char(30), invoice description
inv_date date, invoice date
orig_amount decimal(12), original invoice amount
disc_amt decimal(12), original discount amount
balance decimal(12), current balance
disc_bal decimal(12), current discount balance
due_date date, invoice due date
disc_date date, discount due date
ap_acct_no integer, ap account number inv posted to
ap_department char(3), ap dept invoice posted to
po_no char(10), purchase order number
po_date date, purchase order date
to_pay_amt decimal(12), amount to pay
to_take_disc decimal(12), discount to take
to_pay_date date, to pay date
cash_acct_no integer, cash account number
cash_department char(3), cash account department
currency_code char(3), multicurrency code
curr_ex_rate decimal(16), current exchange rate
home_curr_amount decimal(12),home currency amount
last_pay_date date last pay date
----------------------------------------------------------------
stppytor Vendor Pay to Reference Table
vend_code char(20), vendor code
pay_to_code char(6), vendor payto code
pay_to_name char(30), vendor payto name
contact char(20), payto contact name
phone char(20), pay to phone number
address1 char(30), pay to address line 1
address2 char(30), pay to address line 2
city char(20), pay to city
state char(2), pay to state
zip char(10), pay to zip
country char(20), pay to country
take_dscnt char(1), take discount Y/N/Always
spec_billing char(50), special billing instructions
taxable char(6), taxable - y/n or multilevel tax code
bo_allowed char(1), backordering allowed
pay_method char(6), payment method
buyer_code char(6), buyer code
trd_ds_code char(6), trade discount code
eta_days smallint, estimated time of arrival days
st_tx_code char(6), state tax code - Obsolete field
co_tx_code char(6), county tax code - Obsolete field
ci_tx_code char(6), city tax code - Obsolete field
email char(50), email address
web_address char(50), internet home page
cell_phone char(20), cell phone number
fax_phone char(20) FAX phone number
-----------------------------------------------------------------------
stpractr
acct_no integer, GL account number
department char(3) department
-----------------------------------------------------------------------
stptermr Accounts Payable Vendor Terms Code Reference
terms_code char(6), terms code
terms_desc char(30), terms description
due_days smallint, due days
disc_days smallint, discount days
disc_pct decimal(6) discount percent
----------------------------------------------------------------------
stptranr Accounts Payable Transaction Table
orig_journal char(2) not null original journal code
doc_no integer not null document number
inv_chk_no char(10), invoice or check reference #
doc_type char(2) document type
----------------------------------------------------------------------
stptranv Accounts Payable Document View Table
orig_journal original journal
doc_no document number
post_no posting number
post_date posting date
doc_date document date
ref_code reference code
doc_desc document description
inv_chk_no invoice or check number
doc_type document type
---------------------------------------------------------------------
stpvendr Accounts Payble Vendor Reference Table
vend_code char(20), vendor code
bus_name char(30), business name
contact char(20), contact name
phone char(20), phone number
address1 char(30), address line 1
address2 char(30), address line 2
city char(20), city
state char(2), state
zip char(10), zip
country char(20), country
credit_limit decimal(12), vendor's credit limit
terms_code char(6), vendor's terms code
act_grp char(6), gl account group
spec_billing char(50), special billing instructions
ap_acct_dflt integer, default gl ap account
ap_department_dflt char(3), default gl department
last_pay_date date, last payment date
hold_pymnt char(1), payment on hold
take_dscnt char(1), take discount y/n or always
acct_bal decimal(12), current account balance
on_acct_amt decimal(12), on account amount
arch_bal decimal(12), last archive balance
spec_shipping char(50), special shipping instructions
taxable char(6), multilevel tax code
bo_allowed char(1), backordering allowed
pay_method char(6), payment method
buyer_code char(6), buyer code
trd_ds_code char(6), trade discount code
eta_days smallint, estimated time of arrival days
st_tx_code char(6), state tax code
co_tx_code char(6), county tax code
ci_tx_code char(6), city tax code
cash_acct_no integer, cash account number
cash_department char(3), cash account department
exp_acct_no integer, expense account number
exp_department char(3), expense account department
print_1099 char(1), print 1099?
federal_tax_id char(11), vendor's federal tax id
currency_code char(3), vendor's currency code
acct_bal_date date, account balance date
on_acct_date date, on account date
sdb_code char(10), sbd code
vendor_rating smallint, vendor's rating
fax_phone char(20), fax
telex_no char(20), telex
mtax_frght char(6), freight tax
mtax_misc char(6), misc tax
email char(50), e-mail address
web_address char(50), website
cell_phone char(20) cell phone number
--------------------------------------------------------------------
stpvoidr Accounts Payable Check Voiding Entry Table
chk_doc_no integer, check doc # to void
doc_no serial not null document #
void_date date void date
--------------------------------------------------------------------