AP Tables and Properties

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