AP_InvoiceRegisterWrk AP Invoice Register Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceRegisterWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 4 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 9 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 10 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 11 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 12 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . 13 Adjustment. . . . . . . . . . 1 SNN Adjustment. . . . . . . . . . . 14 PrepaidApplyToInvoiceNo . . . 10 SNN Prepaid Apply To AP Invoice Num 15 PrepaidPaymentDate. . . . . . 8 SNN Prepaid Payment Date. . . . . .DATE 16 PrepaidCheckNo. . . . . . . . 10 SNN Prepaid Check Number. . . . . . 17 VendorType. . . . . . . . . . 1 SNN Vendor Type . . . . . . . . . . 18 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . . 19 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . 20 SeparateCheck . . . . . . . . 1 SNN Separate Check. . . . . . . . . 21 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . . 22 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 23 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 24 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 25 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 26 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 27 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 28 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 29 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 30 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 31 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 32 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 33 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 34 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 35 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 36 TransferVendorName. . . . . . 30 SNN Transfer Vendor Name. . . . . . 37 TransferInvoiceNo . . . . . . 10 SNN Transfer Invoice Number . . . . 38 TransferVendorType. . . . . . 1 SNN Transfer Vendor Type. . . . . . 39 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . . 40 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . . 41 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . . 42 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . . 43 Overridden. . . . . . . . . . 1 SNN Overridden. . . . . . . . . . . 44 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . . 45 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 46 PrepaymentAmt . . . . . . . . 13.2 NNN Prepayment Amount . . . . . . . 47 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . . 48 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . . 49 QuantityDistributed . . . . . 16.6 NNN Quantity Distributed. . . . . . 50 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . . 51 RetentionRate . . . . . . . . 7.2 NNN Retention Rate. . . . . . . . . 52 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 53 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . . 54 TransferDiscount. . . . . . . 13.2 NNN Transfer Discount . . . . . . . 55 TaxDetailAmt. . . . . . . . . 13.2 NNN Tax Detail Amount . . . . . . .