Back
Manufacturing (MA) - MAORDEHT
| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ORDNUM |
String |
8 |
|
|
MA ORDNUM |
| NUMBER |
String |
10 |
|
|
MA NUMBER |
| ORDDATE |
DateTime |
8 |
|
|
MA ORDDATE |
| TIME |
String |
7 |
|
|
MA TIME |
| ORDTYPE |
String |
1 |
|
|
MA ORDTYPE |
| ORIGIN |
String |
1 |
|
|
MA ORIGIN |
| REPORDNUM |
String |
8 |
|
|
MA REPORDNUM |
| ORIGORDNUM |
String |
8 |
|
|
MA ORIGORDNUM |
| INVNUM |
String |
12 |
|
|
MA INVNUM |
| NAME |
String |
30 |
|
|
MA NAME |
| ADDRESS1 |
String |
40 |
|
|
MA ADDRESS1 |
| ADDRESS2 |
String |
40 |
|
|
MA ADDRESS2 |
| CITY |
String |
20 |
|
|
MA CITY |
| STATE |
String |
10 |
|
|
MA STATE |
| ZIP |
String |
10 |
|
|
MA ZIP |
| COUNTRY |
String |
30 |
|
|
MA COUNTRY |
| CONTACT |
String |
30 |
|
|
MA CONTACT |
| CRED1OR2 |
String |
1 |
|
|
MA CRED1OR2 |
| CREDCARD |
String |
4 |
|
|
MA CREDCARD |
| CREDDATE |
String |
10 |
|
|
MA CREDDATE |
| CREDNUM |
String |
22 |
|
|
MA CREDNUM |
| CREDLINE1 |
String |
30 |
|
|
MA CREDLINE1 |
| CREDLINE2 |
String |
30 |
|
|
MA CREDLINE2 |
| SHIPCODE |
String |
5 |
|
|
MA SHIPCODE |
| SHIPNAME |
String |
30 |
|
|
MA SHIPNAME |
| SHIPADD1 |
String |
40 |
|
|
MA SHIPADD1 |
| SHIPADD2 |
String |
40 |
|
|
MA SHIPADD2 |
| SHIPCITY |
String |
20 |
|
|
MA SHIPCITY |
| SHIPST |
String |
10 |
|
|
MA SHIPST |
| SHIPZIP |
String |
10 |
|
|
MA SHIPZIP |
| SHIPCTRY |
String |
30 |
|
|
MA SHIPCTRY |
| SHIPPHONE |
String |
10 |
|
|
MA SHIPPHONE |
| STATUS |
String |
1 |
|
|
MA STATUS |
| CUSTPONUM |
String |
10 |
|
|
MA CUSTPONUM |
| SHIPVIA |
String |
15 |
|
|
MA SHIPVIA |
| ZONE |
String |
5 |
|
|
MA ZONE |
| FOB |
String |
15 |
|
|
MA FOB |
| COMPWHSE |
String |
8 |
|
|
MA COMPWHSE |
| DESTWHSE |
String |
8 |
|
|
MA DESTWHSE |
| TERMCODE |
String |
2 |
|
|
MA TERMCODE |
| INVTYPE |
String |
2 |
|
|
MA INVTYPE |
| SLPCODE |
String |
5 |
|
|
MA SLPCODE |
| SLP1 |
String |
5 |
|
|
MA SLP1 |
| SLP2 |
String |
5 |
|
|
MA SLP2 |
| SLP3 |
String |
5 |
|
|
MA SLP3 |
| SLP4 |
String |
5 |
|
|
MA SLP4 |
| TCODE_1 |
String |
3 |
|
|
MA TCODE_1 |
| TCODE_2 |
String |
3 |
|
|
MA TCODE_2 |
| TCODE_3 |
String |
3 |
|
|
MA TCODE_3 |
| PRTSTATUS |
String |
1 |
|
|
MA PRTSTATUS |
| SHIPSTATUS |
String |
1 |
|
|
MA SHIPSTATUS |
| FRE_TAX |
String |
1 |
|
|
MA FRE_TAX |
| CATCODE |
String |
3 |
|
|
MA CATCODE |
| AROVERRIDE |
String |
12 |
|
|
MA AROVERRIDE |
| MISACCT |
String |
12 |
|
|
MA MISACCT |
| TAXACCT |
String |
12 |
|
|
MA TAXACCT |
| FREACCT |
String |
12 |
|
|
MA FREACCT |
| DISCACCT |
String |
12 |
|
|
MA DISCACCT |
| ARCUST |
String |
10 |
|
|
MA ARCUST |
| USERID |
String |
4 |
|
|
MA USERID |
| OVERFRT |
Boolean |
1 |
|
|
MA OVERFRT |
| OVERWGT |
Boolean |
1 |
|
|
MA OVERWGT |
| OVERDISC |
Boolean |
1 |
|
|
MA OVERDISC |
| OVERTAX |
Boolean |
1 |
|
|
MA OVERTAX |
| INVDATE |
DateTime |
8 |
|
|
MA INVDATE |
| DUEDATE |
DateTime |
8 |
|
|
MA DUEDATE |
| COMMENT |
String |
4 |
|
|
MA COMMENT |
| TAX_RATE |
Decimal |
6 |
3 |
|
MA TAX_RATE |
| DISCPERC |
Decimal |
5 |
3 |
|
MA DISCPERC |
| TAX |
Decimal |
8 |
2 |
|
MA TAX |
| FTAX |
Decimal |
8 |
2 |
|
MA FTAX |
| NTAXTOT |
Decimal |
11 |
2 |
|
MA NTAXTOT |
| FNTAXTOT |
Decimal |
11 |
2 |
|
MA FNTAXTOT |
| TAXTOT |
Decimal |
11 |
2 |
|
MA TAXTOT |
| FTAXTOT |
Decimal |
11 |
2 |
|
MA FTAXTOT |
| SUBTOCOMM |
Decimal |
11 |
2 |
|
MA SUBTOCOMM |
| FSUBTOCOMM |
Decimal |
11 |
2 |
|
MA FSUBTOCOMM |
| TOTALCOMM |
Decimal |
11 |
2 |
|
MA TOTALCOMM |
| FTOTALCOMM |
Decimal |
11 |
2 |
|
MA FTOTALCOMM |
| INVTOT |
Decimal |
12 |
2 |
|
MA INVTOT |
| FINVTOT |
Decimal |
12 |
2 |
|
MA FINVTOT |
| ORDTOT |
Decimal |
12 |
2 |
|
MA ORDTOT |
| FORDTOT |
Decimal |
12 |
2 |
|
MA FORDTOT |
| FREIGHT |
Decimal |
8 |
2 |
|
MA FREIGHT |
| FFREIGHT |
Decimal |
8 |
2 |
|
MA FFREIGHT |
| MISC |
Decimal |
8 |
2 |
|
MA MISC |
| FMISC |
Decimal |
8 |
2 |
|
MA FMISC |
| DEPOSIT |
Decimal |
8 |
2 |
|
MA DEPOSIT |
| FDEPOSIT |
Decimal |
8 |
2 |
|
MA FDEPOSIT |
| DISCAMT |
Decimal |
8 |
2 |
|
MA DISCAMT |
| FDISCAMT |
Decimal |
8 |
2 |
|
MA FDISCAMT |
| SUBTODISC |
Decimal |
8 |
2 |
|
MA SUBTODISC |
| FSUBTODISC |
Decimal |
8 |
2 |
|
MA FSUBTODISC |
| COSTCOMM |
Decimal |
8 |
2 |
|
MA COSTCOMM |
| FCOSTCOMM |
Decimal |
8 |
2 |
|
MA FCOSTCOMM |
| SLPCOMM |
Decimal |
5 |
2 |
|
MA SLPCOMM |
| SLPCOMM1 |
Decimal |
5 |
2 |
|
MA SLPCOMM1 |
| SLPCOMM2 |
Decimal |
5 |
2 |
|
MA SLPCOMM2 |
| SLPCOMM3 |
Decimal |
5 |
2 |
|
MA SLPCOMM3 |
| SLPCOMM4 |
Decimal |
5 |
2 |
|
MA SLPCOMM4 |
| COMMTOT |
Decimal |
8 |
2 |
|
MA COMMTOT |
| FCOMMTOT |
Decimal |
8 |
2 |
|
MA FCOMMTOT |
| COMMTOT1 |
Decimal |
8 |
2 |
|
MA COMMTOT1 |
| FCOMMTOT1 |
Decimal |
8 |
2 |
|
MA FCOMMTOT1 |
| COMMTOT2 |
Decimal |
8 |
2 |
|
MA COMMTOT2 |
| FCOMMTOT2 |
Decimal |
8 |
2 |
|
MA FCOMMTOT2 |
| COMMTOT3 |
Decimal |
8 |
2 |
|
MA COMMTOT3 |
| FCOMMTOT3 |
Decimal |
8 |
2 |
|
MA FCOMMTOT3 |
| COMMTOT4 |
Decimal |
8 |
2 |
|
MA COMMTOT4 |
| FCOMMTOT4 |
Decimal |
8 |
2 |
|
MA FCOMMTOT4 |
| SLPPERC |
Decimal |
6 |
2 |
|
MA SLPPERC |
| SLPPERC1 |
Decimal |
6 |
2 |
|
MA SLPPERC1 |
| SLPPERC2 |
Decimal |
6 |
2 |
|
MA SLPPERC2 |
| SLPPERC3 |
Decimal |
6 |
2 |
|
MA SLPPERC3 |
| SLPPERC4 |
Decimal |
6 |
2 |
|
MA SLPPERC4 |
| WEIGHT |
Decimal |
8 |
2 |
|
MA WEIGHT |
| NUMLABELS |
Decimal |
3 |
0 |
|
MA NUMLABELS |
| SHIPAREA |
String |
10 |
|
|
MA SHIPAREA |
| PAYTYPE |
Int32 |
4 |
|
|
MA PAYTYPE |
| PREPAYNUM |
String |
12 |
|
|
MA PREPAYNUM |
| NOAUTOPO |
Boolean |
1 |
|
|
MA NOAUTOPO |
| DISCDUE |
DateTime |
8 |
|
|
MA DISCDUE |
| INVOICEPRT |
Boolean |
1 |
|
|
MA INVOICEPRT |
| ORDERPRT |
Boolean |
1 |
|
|
MA ORDERPRT |
| PACKPRT |
Boolean |
1 |
|
|
MA PACKPRT |
| DELDATE |
DateTime |
8 |
|
|
MA DELDATE |
| ISPRINTED |
Boolean |
1 |
|
|
MA ISPRINTED |
| FAXPRT |
Boolean |
1 |
|
|
MA FAXPRT |
| EMAILPRT |
Boolean |
1 |
|
|
MA EMAILPRT |
| EMAIL |
String |
40 |
|
|
MA EMAIL |
| FAX |
String |
15 |
|
|
MA FAX |
| AREAFAX |
String |
10 |
|
|
MA AREAFAX |
| NOTES |
String |
4 |
|
|
MA NOTES |
| BILLITEM |
String |
25 |
|
|
MA BILLITEM |
| QUANTITY |
Decimal |
10 |
4 |
|
MA QUANTITY |
| QTYPROD |
Decimal |
10 |
4 |
|
MA QTYPROD |
| LASTACT |
DateTime |
8 |
|
|
MA LASTACT |
| SALESORDER |
String |
8 |
|
|
MA SALESORDER |
| SOKEYID |
String |
12 |
|
|
MA SOKEYID |
| WIPACCT |
String |
12 |
|
|
MA WIPACCT |
| INVACCT |
String |
12 |
|
|
MA INVACCT |
| WIPTOT |
Decimal |
12 |
4 |
|
MA WIPTOT |
| SERLOTRCPT |
String |
15 |
|
|
MA SERLOTRCPT |
| QTYBUILT |
Decimal |
10 |
4 |
|
MA QTYBUILT |
| QTYORIG |
Decimal |
10 |
4 |
|
MA QTYORIG |
| WIPMTL |
Decimal |
12 |
4 |
|
MA WIPMTL |
| WIPLABOR |
Decimal |
12 |
4 |
|
MA WIPLABOR |
| OVERHEAD |
Decimal |
12 |
4 |
|
MA OVERHEAD |
| DIRLABOR |
Decimal |
12 |
4 |
|
MA DIRLABOR |