AR_InvoiceHistoryWrk AR Invoice History Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_InvoiceHistoryReport_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryWrk"+%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 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
4 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . .
5 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE
6 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . .
7 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
8 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . .MODULECODE
9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
11 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .
12 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .SALESORDERNO
13 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . .
14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
15 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .
16 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . .
17 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .
18 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . .SALESPERSONNO
19 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .
20 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
21 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .
22 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .
23 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .
24 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .
25 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . .
26 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . .
27 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . .
28 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . .NAME
29 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .
30 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .
31 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .
32 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .
33 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .
34 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .
35 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .
36 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .
37 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .NAME
38 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
39 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
40 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . .RMANO
41 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO
42 CheckNoForDeposit . . . . . . 7 SNN Check Number For Deposit. . . .
43 SplitCommissions. . . . . . . 1 SNN Split Commissions . . . . . . .
44 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .
45 SalespersonNo2. . . . . . . . 4 SNN Salesperson Number 2. . . . . .
46 SalespersonName2. . . . . . . 30 SNN Salesperson Name2 . . . . . . .
47 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .
48 SalespersonNo3. . . . . . . . 4 SNN Salesperson Number 3. . . . . .
49 SalespersonName3. . . . . . . 30 SNN Salesperson Name3 . . . . . . .
50 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .
51 SalespersonNo4. . . . . . . . 4 SNN Salesperson Number 4. . . . . .
52 SalespersonName4. . . . . . . 30 SNN Salesperson Name4 . . . . . . .
53 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .
54 SalespersonNo5. . . . . . . . 4 SNN Salesperson Number 5. . . . . .
55 SalespersonName5. . . . . . . 30 SNN Salesperson Name5 . . . . . . .
56 EBMSubmissionType . . . . . . 1 SNN EBM Submission Type . . . . . .
57 EBMUserIDSubmittingThisOrder. 15 SNN EBM User ID Submitting This Ord
58 EBMUserType . . . . . . . . . 1 SNN EBM User Type . . . . . . . . .
59 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .TAXSCHEDULE
60 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .ITEMCODE
61 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
62 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
63 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account .
64 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .WAREHOUSE
65 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .UNITOFMEASURE
66 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . .
67 Discount. . . . . . . . . . . 1 SNN Discount. . . . . . . . . . . .
68 Commissionable. . . . . . . . 1 SNN Commissionable. . . . . . . . .
69 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . .TAXCLASS
70 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . .
71 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . .
72 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . .DESCRIPTION25
73 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
74 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . .
75 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . .
76 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . .COSTCODE
77 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . .
78 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . .COSTTYPE
79 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
80 TaxDetailFormatted. . . . . . 460 SNN Tax Detail Formatted. . . . . .
81 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
82 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . .
83 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . .
84 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
85 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . .
86 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
87 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . .
88 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . .
89 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
90 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . .
91 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .
92 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .
93 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .
94 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .
95 SplitcommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .
96 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .
97 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .
98 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .
99 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
100 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .
101 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .
102 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .
103 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .
104 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .
105 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .
106 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .
107 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
108 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .
109 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percentage. . . .
110 LotSerialQuantityShipped. . . 16.6 NNN Lot Serial Quantity Shipped . .