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),

mailed_date date date check was mailed

pospay_sent char(1), Positive Pay file Sent Y/N

send_pospay char(1) Send Positive Pay file Y/N

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

auto_invce_post char(1), Real Time Processing auto invoice post

auto_check_post char(1), Real Time Processing auto check post

auto_vdcheck_post char(1), Real Time Processing auto void check post

auto_invce_post_d char(1), Real Time Processing auto invoice post

auto_check_post_d char(1), Real Time Processing auto check post

auto_vdchk_post_d char(1) Real Time Processing auto void check post

----------------------------------------------------------------

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

prod_order char(7), Prod Order

prod_order_lot char(3), Prod Order Lot

element char(20) Element

---------------------------------------------------------------

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(20), 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(20), 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(2), 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

cc_ap_acct_no integer, AP account number

cc_ap_department char(3) AP department

-----------------------------------------------------------------------

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(2), 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

account_no char(20) vendor account

ytd_purchases decimal(14), YTD Purchases

lifetime_purchases dec(14) Lifetime Purchases

open_po_amt decimal(14), Total Open PO Amount

reb_recv_acct_no integer Rebate Receive Account Number

cc_template char(20) Template

--------------------------------------------------------------------

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

--------------------------------------------------------------------