Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PABILLTRXT | PA Biller Trx Type |
Integer | 2 | View | |
PADocnumber20 | PA Document No. |
String | 18 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
PADOCDT | PA Document Date |
Date | 4 | View | |
PAPD | PA Post Date |
Date | 4 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
PAuserid | PA User ID |
String | 16 | View | |
LSTEDTDT | Last Edit Date |
Date | 4 | View | |
LSTUSRED | Last User to Edit |
String | 16 | View | |
PAREFNO | PA Reference Document No. |
String | 18 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CSTPONBR | Customer PO Number |
String | 22 | View | |
PRBTADCD | Primary Billto Address Code |
String | 16 | View | |
PYMTRMID | Payment Terms ID |
String | 22 | View | |
PABILLFORMAT | PA Bill Format |
String | 16 | View | |
PACOMM | PA Comment |
String | 52 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
PAUD1 | PA User Defined 1 |
String | 22 | View | |
PAUD2 | PA User Defined 2 |
String | 22 | View | |
CASHAMNT | Cash Amount |
Currency | 10 | View | |
CBKIDCSH | Checkbook ID Cash |
String | 16 | View | |
CASHDATE | Cash Date |
Date | 4 | View | |
DCNUMCSH | Document Number Cash |
String | 22 | View | |
CHEKAMNT | Check Amount |
Currency | 10 | View | |
CBKIDCHK | Checkbook ID Check |
String | 16 | View | |
CHEKNMBR | Check Number |
String | 22 | View | |
CHEKDATE | Check Date |
Date | 4 | View | |
DCNUMCHK | Document Number Check |
String | 22 | View | |
CRCRDAMT | Credit Card Amount |
Currency | 10 | View | |
CRCRDNAM | Credit Card Name |
String | 16 | View | |
RCTNCCRD | Receipt Number Credit Card |
String | 22 | View | |
CRCARDDT | Credit Card Date |
Date | 4 | View | |
DCNUMCRD | Document Number Credit Card |
String | 22 | View | |
DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
DISAVAMT | Discount Available Amount |
Currency | 10 | View | |
DISCAMNT | Discount Amount |
Currency | 10 | View | |
DISCDATE | Discount Date |
Date | 4 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
DISCRTND | Discount Returned |
Currency | 10 | View | |
PABillingAmount | PA Billing Amount |
Currency | 10 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
PA_Freight_Amount | PA Freight Amount |
Currency | 10 | View | |
PA_Misc_Amount | PA Misc Amount |
Currency | 10 | View | |
FRTTXAMT | Freight Tax Amount |
Currency | 10 | View | |
MSCTXAMT | Misc Tax Amount |
Currency | 10 | View | |
PATOTTAX | PA Total Tax |
Currency | 10 | View | |
PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
BKTFRTAM | Backout Freight Amount |
Currency | 10 | View | |
BKTMSCAM | Backout Misc Amount |
Currency | 10 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
APPLDAMT | Applied Amount |
Currency | 10 | View | |
PALastDateApplied | PA Last Date Applied |
Date | 4 | View | |
SLPRSNID | Salesperson ID |
String | 16 | View | |
SALSTERR | Sales Territory |
String | 16 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
COMAPPTO | Commission Applied To |
Integer | 2 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
CUTOFDAT | Cutoff Date |
Date | 4 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
MSCSCHID | Misc Schedule ID |
String | 16 | View | |
MISCTXBL | Misc Taxable 1 = Taxable |
Integer | 2 | View | |
FRTSCHID | Freight Schedule ID |
String | 16 | View | |
FRGTTXBL | Freight Taxable 1 = Taxable |
Integer | 2 | View | |
PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
PAtotbillings | PA Total Billings |
Currency | 10 | View | |
PAlastprtby | PA Last Printed By |
String | 16 | View | |
PAlastprtdate | PA Last Printed Date |
Date | 4 | View | |
ORCASAMT | Originating Cash Amount |
Currency | 10 | View | |
ORCHKAMT | Originating Check Amount |
Currency | 10 | View | |
ORCCDAMT | Originating Credit Card Amount |
Currency | 10 | View | |
ORDDLRAT | Originating Discount Dollar Amount |
Currency | 10 | View | |
ORDAVAMT | Originating Discount Available Amount |
Currency | 10 | View | |
ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
ORFRTTAX | Originating Freight Tax Amount |
Currency | 10 | View | |
ORMSCTAX | Originating Misc Tax Amount |
Currency | 10 | View | |
ORBKTFRT | Originating Backout Freight Amount |
Currency | 10 | View | |
ORBKTMSC | Originating Backout Misc Amount |
Currency | 10 | View | |
ORDOCAMT | Originating Document Amount |
Currency | 10 | View | |
ORAPPAMT | Originating Applied Amount |
Currency | 10 | View | |
ORCOMAMT | Originating Commission Dollar Amount |
Currency | 10 | View | |
PAOrigBillAmount | PA Originating Billing Amount |
Currency | 10 | View | |
PAOrigFreightAmt | PA Originating Freight Amount |
Currency | 10 | View | |
PAOrigMiscAmt | PA Originating Misc Amount |
Currency | 10 | View | |
PAOrigTotalTaxAmt | PA Originating Total Tax |
Currency | 10 | View | |
PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
Currency | 10 | View | |
PAOrigRetainerFeeAmt | PA Originating Retainer Fee Amt |
Currency | 10 | View | |
PAOrigTotalBilings | PA Originating Total Billings |
Currency | 10 | View | |
PAOrigDiscTakenAmt | PA Originating Discount Taken Amt |
Currency | 10 | View | |
PAOrigDiscRetAmt | PA Originating Discount Returned Amt |
Currency | 10 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View | |
RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
PAPostoDynRM | PA Post to Dyn Receivables Mgmt |
Boolean | 2 | View | |
Tax_Date | Tax Date |
Date | 4 | View | |
PA_Third_Party_CB | PA Third Party CB |
Boolean | 2 | View | |
BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
BackoutTradeDiscTax | Backout Trade Discount Tax Amount |
Currency | 10 | View | |
OrigBackoutTradeDiscTax | Originating Backout Trade Discount Tax Amount |
Currency | 10 | View | |
PA_Backout_Retention_Tax | PA Backout Retention Tax Amount |
Currency | 10 | View | |
PA_OrigBackRetentionTax | PA Originating Backout Retention Tax Amount |
Currency | 10 | View |