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 2nd 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 |