AP Tables and Properties

List of AP properties for AP Records

Label	Table	Column	Type	Size	BT20Object	Property
Item No	ohb_batch_dtl	ohb_rec_no	smallint	5	BT20.OHBBatchDetail	RecNo
Vendor	ohb_batch_dtl	oh_pe_id	char	12	BT20.OHBBatchDetail	PeId
Invoice	ohb_batch_dtl	oh_ref	char	16	BT20.OHBBatchDetail	Ref
Div	ohb_batch_dtl	oh_div	char	4	BT20.OHBBatchDetail	Div
Account	ohb_batch_dtl	oh_gl_gr	char	2	BT20.OHBBatchDetail	GlGr
Org Key	ohb_batch_dtl	oh_gl_key	char	10	BT20.OHBBatchDetail	GlKey
Object	ohb_batch_dtl	oh_gl_obj	char	8	BT20.OHBBatchDetail	GlObj
Account	ohb_batch_dtl	oh_jl_gr	char	2	BT20.OHBBatchDetail	JlGr
Org Key	ohb_batch_dtl	oh_jl_key	char	10	BT20.OHBBatchDetail	JlKey
TASK	ohb_batch_dtl	oh_jl_obj	char	8	BT20.OHBBatchDetail	JlObj
Work Order	ohb_batch_dtl	oh_wo	char	12	BT20.OHBBatchDetail	Wo
Second Ref	ohb_batch_dtl	oh_sec_ref	char	16	BT20.OHBBatchDetail	SecRef
Dist Amount	ohb_batch_dtl	oh_dist_amt	numeric	20,2	BT20.OHBBatchDetail	DistAmt
Disc. Terms	ohb_batch_dtl	oh_disc_terms	numeric	5,4	BT20.OHBBatchDetail	DiscTerms
Discount	ohb_batch_dtl	oh_disc_amt	numeric	20,2	BT20.OHBBatchDetail	DiscAmt
Tax Code	ohb_batch_dtl	oh_tax_cd	char	4	BT20.OHBBatchDetail	TaxCd
Tax Amount	ohb_batch_dtl	oh_tax_amt	numeric	20,2	BT20.OHBBatchDetail	TaxAmt
Tax Code 2	ohb_batch_dtl	oh_tax_cd2	char	4	BT20.OHBBatchDetail	TaxCd2
Tax Amount 2	ohb_batch_dtl	oh_tax_amt2	numeric	20,2	BT20.OHBBatchDetail	TaxAmt2
Charge Code	ohb_batch_dtl	oh_charge_cd	char	4	BT20.OHBBatchDetail	ChargeCd
Charge Amount	ohb_batch_dtl	oh_charge_amt	numeric	20,2	BT20.OHBBatchDetail	ChargeAmt
Duty Code	ohb_batch_dtl	oh_duty_cd	char	4	BT20.OHBBatchDetail	DutyCd
Duty Amount	ohb_batch_dtl	oh_duty_amt	numeric	20,2	BT20.OHBBatchDetail	DutyAmt
Invoice Amount	ohb_batch_dtl	oh_ref_amt	numeric	20,2	BT20.OHBBatchDetail	RefAmt
Retail Amount	ohb_batch_dtl	oh_retail_amt	numeric	20,2	BT20.OHBBatchDetail	RetailAmt
Description	ohb_batch_dtl	oh_desc	char	30	BT20.OHBBatchDetail	Desc
Misc	ohb_batch_dtl	oh_misc	char	4	BT20.OHBBatchDetail	Misc
Relate 1	ohb_batch_dtl	oh_rel_one	char	2	BT20.OHBBatchDetail	RelOne
Relate 2	ohb_batch_dtl	oh_rel_two	char	2	BT20.OHBBatchDetail	RelTwo
Set ID	ohb_batch_dtl	oh_batch_id	char	16	BT20.OHBBatchDetail	BatchId
Due Date	ohb_batch_dtl	oh_due_dt	datetime	19	BT20.OHBBatchDetail	DueDt
Received Date	ohb_batch_dtl	oh_rcvd_dt	datetime	19	BT20.OHBBatchDetail	RcvdDt
Authorized Date	ohb_batch_dtl	oh_auth_dt	datetime	19	BT20.OHBBatchDetail	AuthDt
Posting Code Transaction	ohb_batch_dtl	oh_post_cd	char	2	BT20.OHBBatchDetail	PostCd
Format	ohb_batch_dtl	oh_trns_format	char	2	BT20.OHBBatchDetail	TrnsFormat
Status	ohb_batch_dtl	oh_status	char	2	BT20.OHBBatchDetail	Status
Job Number	ohb_batch_dtl	oh_job_no	integer	10	BT20.OHBBatchDetail	JobNo
Addr Cd	ohb_batch_dtl	oh_pe_addr_cd	char	2	BT20.OHBBatchDetail	PeAddrCd
Prep ID	ohb_batch_dtl	oh_prep_id	char	12	BT20.OHBBatchDetail	PrepId
Product ID	ohb_batch_dtl	oh_prod_id	char	16	BT20.OHBBatchDetail	ProdId
Quantity	ohb_batch_dtl	oh_units	numeric	20,5	BT20.OHBBatchDetail	Units
Unit Price	ohb_batch_dtl	oh_unit_price	numeric	20,5	BT20.OHBBatchDetail	UnitPrice
Units of Measure	ohb_batch_dtl	oh_msur	char	8	BT20.OHBBatchDetail	Msur
P/F	ohb_batch_dtl	oh_encb_part	char	2	BT20.OHBBatchDetail	EncbPart
PO#	ohb_batch_dtl	oh_encb_po	char	8	BT20.OHBBatchDetail	EncbPo
PR #	ohb_batch_dtl	oh_pr_no	char	8	BT20.OHBBatchDetail	PrNo
PR Item #	ohb_batch_dtl	oh_pr_item	char	4	BT20.OHBBatchDetail	PrItem
Bank ID	ohb_batch_dtl	oh_check_id	char	2	BT20.OHBBatchDetail	CheckId
Check No	ohb_batch_dtl	oh_check_no	char	8	BT20.OHBBatchDetail	CheckNo
Check Date	ohb_batch_dtl	oh_ck_dt	datetime	19	BT20.OHBBatchDetail	CkDt
Check Job	ohb_batch_dtl	oh_ck_job	integer	10	BT20.OHBBatchDetail	CkJob
Former Bank ID	ohb_batch_dtl	oh_former_id	char	2	BT20.OHBBatchDetail	FormerId
Former Check No	ohb_batch_dtl	oh_former_no	char	8	BT20.OHBBatchDetail	FormerNo
Sep Check	ohb_batch_dtl	oh_sep_check	char	2	BT20.OHBBatchDetail	SepCheck
Refund Type	ohb_batch_dtl	oh_refund_type	char	2	BT20.OHBBatchDetail	RefundType
Sequence No	ohb_batch_dtl	oh_seq_no	smallint	5	BT20.OHBBatchDetail	SeqNo
Vendor Account	ohb_batch_dtl	oh_vend_acct	char	16	BT20.OHBBatchDetail	VendAcct
Bid	ohb_batch_dtl	oh_bid	char	16	BT20.OHBBatchDetail	Bid
Contract	ohb_batch_dtl	oh_contract	char	16	BT20.OHBBatchDetail	Contract
Post Date	ohb_batch_dtl	oh_post_dt	datetime	19	BT20.OHBBatchDetail	PostDt
Invoice Date	ohb_batch_dtl	oh_ref_dt	datetime	19	BT20.OHBBatchDetail	RefDt
PE Name	ohb_batch_dtl	ohb_pe_name	char	22	BT20.OHBBatchDetail	PeName
PEDB Code	ohb_batch_dtl	ohb_pedb_cd	char	2	BT20.OHBBatchDetail	PedbCd
Security Code	ohb_batch_dtl	ohb_sec_cd	char	4	BT20.OHBBatchDetail	SecCd
PO Type	ohb_batch_dtl	ohb_po_type	char	2	BT20.OHBBatchDetail	PoType
Pay Type	ohb_batch_dtl	ohb_pay_type	char	2	BT20.OHBBatchDetail	PayType
Claim No	ohb_batch_dtl	ohb_claim_no	integer	10	BT20.OHBBatchDetail	ClaimNo
Check Type	ohb_batch_dtl	ohb_check_type	char	2	BT20.OHBBatchDetail	CheckType
Warehouse	ohb_batch_dtl	ohb_warehouse	char	4	BT20.OHBBatchDetail	Warehouse
Image Rec	ohb_batch_dtl	ohb_image_rec	integer	10	BT20.OHBBatchDetail	ImageRec
Data Key	ohb_batch_dtl	ohb_data_key	integer	10	BT20.OHBBatchDetail	DataKey
Calc Flag	ohb_batch_dtl	ohb_calc_flag	char	2	BT20.OHBBatchDetail	CalcFlag
Msg	ohb_batch_dtl	ohb_msg	char	20	BT20.OHBBatchDetail	Msg
Sort	ohb_batch_dtl	ohb_sort	char	30	BT20.OHBBatchDetail	Sort
Catalog	ohb_batch_dtl	ohb_catalog	char	16	BT20.OHBBatchDetail	Catalog
Quantity	ohb_batch_dtl	ohb_poi_qty	numeric	20,3	BT20.OHBBatchDetail	PoiQty
Explode	ohb_batch_dtl	ohb_explode	char	2	BT20.OHBBatchDetail	Explode
Sort Field	ohb_batch_dtl	ohb_sort_field	char	32	BT20.OHBBatchDetail	SortField
Undo Job	ohb_batch_dtl	ohb_undo_job_no	integer	10	BT20.OHBBatchDetail	UndoJobNo
Form Name	ohb_batch_dtl	ohb_form_name	char	16	BT20.OHBBatchDetail	FormName
Delete Flag	ohb_batch_dtl	ohb_delete_flag	smallint	5	BT20.OHBBatchDetail	DeleteFlag
unique_key	ohb_batch_dtl	unique_key	char	36	BT20.OHBBatchDetail	UniqueKey
Vendor of Rec	ohb_batch_dtl	oh_alt_pe_id	char	12	BT20.OHBBatchDetail	AltPeId
Alt PEDB Code	ohb_batch_dtl	oh_alt_pedb_cd	char	2	BT20.OHBBatchDetail	AltPedbCd
Alt Address Code	ohb_batch_dtl	oh_alt_addr_cd	char	2	BT20.OHBBatchDetail	AltAddrCd
Asset ID Received	ohb_batch_dtl	oh_asset_id	char	12	BT20.OHBBatchDetail	AssetId
Quantity	ohb_batch_dtl	ohb_por_qty	numeric	20,3	BT20.OHBBatchDetail	PorQty
ohb_withhold_cd1	ohb_batch_dtl	ohb_withhold_cd1	char	8	BT20.OHBBatchDetail	WithholdCd1
ohb_withhold_cd2	ohb_batch_dtl	ohb_withhold_cd2	char	8	BT20.OHBBatchDetail	WithholdCd2
ohb_withhold_cd3	ohb_batch_dtl	ohb_withhold_cd3	char	8	BT20.OHBBatchDetail	WithholdCd3
ohb_withhold_cd4	ohb_batch_dtl	ohb_withhold_cd4	char	8	BT20.OHBBatchDetail	WithholdCd4
Orig Source	ohb_batch_dtl	ohb_orig_source	char	2	BT20.OHBBatchDetail	OrigSource

Complete list of Properties

Property	Description
AddendaType	EFT payment addenda type
Addr1	Address line 1
Addr1099Cd	Default 1099 address code
Addr2	Address line 2
Addr3	Address line 3
Addr4	Address line 4
AddrCd	Address Code
AffilCd	Affiliation Code
AltAddrCd	Vendor or record address code
AltPedbCd	Vendor or record database code
AltPeId	Vendor or record
AssetId	Asset ID
AuthDt	Authorization Date
BankAcct	EFT bank account
BankRoute	EFT bank routing number
BankType	EFT bank account type (C or S)
BatchId	Set ID
Bid	Bid
CalcFlag	Calc Flag
Catalog	Catalog
ChargeAmt	Charge Amount
ChargeCd	Charge Code
CheckId	Check ID / Check stock
CheckType	Check Type
City	City
CityStateZip	Combined City, State, and Zip
CkDt	Check date
CkJob	Check job number
ClaimNo	Claim number
Contact	Contact name
ContactId	Contact
CountryCd	Country Code
DataKey	Data key
Dba	Doing Business As
DbaPayeeFlag	Use DBA name on Check (Y or N)
Dbe8aFlag	Disadvantaged business flag (Y or N)
DbeDvFlag	Disadvantaged business flag (Y or N)
DbeHubFlag	Disadvantaged business flag (Y or N)
DbeLocFlag	Disadvantaged business flag (Y or N)
DbeMoFlag	Disadvantaged business flag (Y or N)
DbeSmFlag	Disadvantaged business flag (Y or N)
DbeWoFlag	Disadvantaged business flag (Y or N)
DeleteFlag	Delete Flag
Desc	Description
DirSaleFlag	1099 Direct sales > $5000 (Y or N)
DiscChangeResp	When user changes discount (A, B, W)
DiscDays	Number of days between invoice and discount date
DiscountPct	Vendor discount percentage
DiscTerms	Discount terms
DiscTerms-C	Customer discount percentage
DiscAmt	Discount Amount
Div	Division
DueDt	Due Date
DupInvCheck	Duplicate Invoice Check flag (B, N, W)
DutyAmt	Duty amount
DutyCd	Duty Code
EftFlag	EFT payment flag (Y or N)
EftType	EFT payment type (PPD, CCD, etc.)
EmailAddr	Email address (must also provide email type code)
EmailTypeCd	Email type code (must be provided if email is used)
EncbPart	Encumbrance part
EncbPo	Encumbrance purchase order
EntityExpireDt	Vendor expiration date
Explode	Explode
FormerId	Former ID
FormerNo	Former Number
FormerName	Former Name
GlGr	General ledger code
GlKey	General ledger account key
GlObj	General ledger account object
IdStatus	Vendor PE Status (AC, IN, PN)
ImageRec	Image record
JlGr	Job Ledger
JlKey	Job Account Key
JlObj	Job Account Object
JobNo	Job Number
Misc	Miscellaneous
Msg	Msg
Msur	Units of measure
Name	Vendor's complete name
NameFirst	First name
NameLast	Last name
NameMiddle	Middle name
Nickname	Nick name
NoCheckFlag	Prevent checks (Y or N)
NoCheckReas	Prevent checks reason
NoInvFlag	Prevent invoices (Y or N)
NoInvReas	Prevent invoices reason
NoPoFlag	Prevent POs (Y or N)
NoPoReas	Prevent POs reason
NoPrFlag	Prevent PRs (Y or N)
NoPrReas	Prevent PRs reason
OldAcct	Crosswalk Account Number (Naviline)
OrigSource	Original Source
PaymentExtId	External ID
PaymentType	Preferred method of payment (CHK, EFT, EPY1-5)
PayType	Pay Type
PeAddrCd	PE Address Code
PedbCd	PE Data base code
PeId	ID of the person or vendor
PeIdSeed	Seed to use for PEID generation, must be formatted like SYNO/PEIDxxxx
PeName	Person or vendor name
PmtDiscAmt	Payment discount Amount
PmtDiscTaken	Payment discount taken
PmtTermsCd	Payment terms code
PoiQty	Quantity ordered
PorQty	Quantity received
PostCd	Posting code
PoType	PO Type (B, C, or P)
PrepId	Prep ID
PrItem	Purchase requisition item number
PrNo	Purchase requisition number
ProdId	Product ID
RcvdDt	Receive date
RecNo	Record number
Ref	Invoice
RefAmt	Invoice amount
RefDt	Invoice date
RefundType	Refund Type
RelOne	Relate code one
RelTwo	Relate code two
RetailAmt	Retail Amount
SaluteCd	Salutation code
SecurityCd	PE Security code
SelCd1	Select code 1
SelCd2	Select code 2
SoleName	1099 Sole Proprietor name
Ssn	Social Security Number
StateCd	Address state code (2 letters)
Suffix	Name suffix code
TaxChangeResp	When user changes taxes (A, B, W)
TaxPct	Customer tax rate
TaxStatus	Vendor's tax status (O, R, W)
Tin	Tax ID Number
TinFlag2	1099 2^nd TIN notification flag (Y or N)
Url	Vendor's Web address
Vend1099Cd	1099 Business Type
Vend1099Dflt	Vendor's default 1099 type (e.g. CC, RE, etc.)
Vend1099Flag	1099 reporting flag (Y, N, or D)
VendAccount	Account number with vendor
VendPmtTermsCd	Payment Discount Terms Code
VendTaxCd	Preferred tax code
VendTaxCd2	Preferred tax code 2
Warehouse	Warehouse
WitholdCd1	Withholding 1
WitholdCd2	Withholding 2
WitholdCd3	Withholding 3
WitholdCd4	Withholding 4
Wo	Work Order
Zip	Zip Code