Parts Requisition Details
Field Name |
Caption |
Mask |
Description |
Field Type |
RD_COMM_CD |
General Commodity |
10x |
General Commodity |
Text |
RD_COMM_TY |
General Commodity Text |
60x |
General Commodity Text |
Text |
RD_CREDIT |
Credit |
nnnnn.nn |
Credit |
Double |
RD_CRT_BY |
Created By |
25x |
Created By |
Text |
RD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RD_DEPT_CD |
Department |
10x |
Department |
Text |
RD_DEPT_TY |
Department Description |
50x |
Department Text |
Text |
RD_DESC |
General Description |
200x |
General Description |
Text |
RD_DISC |
Discount Percent |
nnnnn.nn |
Discount Percent |
Double |
RD_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
RD_FIXA_CD |
Fixed Asset |
nnn |
Fixed Asset |
Integer |
RD_FIXA_TY |
Fixed Asset Text |
25x |
Fixed Asset Text |
Text |
RD_FREIGHT |
Freight |
nnnnn.nn |
Freight |
Double |
RD_ID |
Requisition Detail Rec # |
nnnnnnnn |
Requisition Details Rec # |
Long Integer |
RD_LINE |
Line |
nnnn |
Line |
Integer |
RD_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
RD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
RD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RD_NEED_DT |
Required By Date |
mm/dd/yyyy |
Required By Date |
Date/Time |
RD_NOTIFY |
Notify Buyer |
|
Notify Buyer |
Boolean |
RD_PA_ID |
Part Rec # |
nnnnnnnn |
Long Integer |
|
RD_PARTDESC |
Description |
75x |
Description |
Text |
RD_PARTNO |
Part ID |
20x |
Part ID |
Text |
RD_PD_ID |
PO Detail Rec # |
nnnnnnnn |
Long Integer |
|
RD_PROCFIN |
Processed By Financials |
|
Processed By Financials |
Boolean |
RD_PV_ID |
Vendor Rec # |
nnnnnnnn |
Long Integer |
|
RD_PW_ID |
Warehouse Rec # |
nnnnnnnn |
Long Integer |
|
RD_QTY_R |
Quantity Requisitioned |
nnnnn.nn |
Quantity Requisitioned |
Double |
RD_REQB_CD |
Requested By |
20x |
Requested By |
Text |
RD_REQB_TY |
Requested By Name |
40x |
Requested By Text |
Text |
RD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RD_RP_ID |
Requisition Rec # |
nnnnnnnn |
Long Integer |
|
RD_SENTFIN |
Sent to Financials |
|
Sent to Financials |
Boolean |
RD_STAT_CD |
Status |
|
Status |
Small Integer |
RD_STAT_TY |
Status Text |
25x |
Status Text |
String |
RD_TCSTEST |
Estimated Total Cost |
nnnnn.nn |
Estimated Total Cost |
Double |
RD_TYPE_CD |
Type |
nnn |
Type |
Integer |
RD_TYPE_TY |
Type Text |
25x |
Type Text |
Text |
RD_UNITEST |
Estimated Unit Cost |
nnnnn.nn |
Estimated Unit Cost |
Double |
RD_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
RD_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure Text |
Text |
RD_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RD_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RD_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
RD_USER13 |
User 13 |
|
User 13 |
Boolean |
RD_USER14 |
User 14 |
|
User 14 |
Boolean |
RD_USER15 |
User 15 |
|
User 15 |
Boolean |
RD_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
RD_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
RD_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
RD_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
RD_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
RD_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
RD_USER4 |
User 4 |
30x |
User 4 |
Text |
RD_USER5 |
User 5 |
30x |
User 5 |
Text |
RD_USER6 |
User 6 |
30x |
User 6 |
Text |
RD_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
RD_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
RD_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
RD_WDESC |
Warehouse Desc. |
50x |
Warehouse Description |
Text |
RD_WNUMBER |
Warehouse ID |
20x |
Warehouse ID |
Text |
RD_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
RD_WR_ID |
WO Resource Rec # |
nnnnnnnn |
Long Integer |