Parts Requisitions
Field Name |
Caption |
Mask |
Description |
Field Type |
RP_COMM_CD |
General Commodity |
10x |
General Commodity |
Text |
RP_COMM_TY |
General Commodity Text |
60x |
General Commodity Text |
Text |
RP_CRT_BY |
Created By |
25x |
Created By |
Text |
RP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RP_DEPT_CD |
Department |
10x |
Department |
Text |
RP_DEPT_TY |
Department Description |
50x |
Department Text |
Text |
RP_DESC |
General Description |
100x |
General Description |
Text |
RP_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
RP_ENTR_CD |
Entered By |
20x |
Entered By |
Text |
RP_ENTR_DT |
Entered Date |
mm/dd/yyyy |
Entered Date |
Date/Time |
RP_ENTR_TY |
Entered By Name |
40x |
Entered By Text |
Text |
RP_FYR |
Fiscal Year |
nnnn |
Fiscal Year |
Integer |
RP_ID |
Parts Requisition Rec # |
nnnnnnnn |
Parts Requisition Rec # |
Long Integer |
RP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
RP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
RP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RP_NEED_DT |
Needed By Date |
mm/dd/yyyy |
Needed By Date |
Date/Time |
RP_NUMBER |
Requisition No |
30x |
Requisition Number |
Text |
RP_PO_ID |
Purchase Order Rec # |
nnnnnnnn |
Long Integer |
|
RP_PROCFIN |
Processed By Financials |
|
Processed By Financials |
Boolean |
RP_PV_ID |
Vendor Rec # |
nnnnnnnn |
Link to PTVENDOR.PV_ID |
Long Integer |
RP_PW_ID |
Warehouse Rec # |
nnnnnnnn |
Long Integer |
|
RP_REF |
Reference |
75x |
Reference |
Text |
RP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RP_SENTFIN |
Sent to Financials |
|
Sent to Financials |
Boolean |
RP_STAT_CD |
Status |
nnn |
Status |
Integer |
RP_STAT_TY |
Status Text |
25x |
Status Text |
Text |
RP_TAMOUNT |
Total Amount |
-nnnnnnnn.nn |
Total Amount |
Double |
RP_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RP_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RP_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
RP_USER13 |
User 13 |
|
User 13 |
Boolean |
RP_USER14 |
User 14 |
|
User 14 |
Boolean |
RP_USER15 |
User 15 |
|
User 15 |
Boolean |
RP_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
RP_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
RP_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
RP_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
RP_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
RP_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
RP_USER4 |
User 4 |
30x |
User 4 |
Text |
RP_USER5 |
User 5 |
30x |
User 5 |
Text |
RP_USER6 |
User 6 |
30x |
User 6 |
Text |
RP_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
RP_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
RP_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
RP_VADDR1 |
Vendor Address |
75x |
Vendor Address Line 1: |
Text |
RP_VADDR2 |
Vendor Address 2 |
75x |
Vendor Address Line 2: |
Text |
RP_VCITY |
Vendor City |
25x |
Vendor City: |
Text |
RP_VCONTACT |
Vendor Contact Name |
30x |
Vendor Contact Name |
Text |
RP_VDESC |
Vendor Description |
50x |
Vendor Description |
Text |
RP_VNUMBER |
Vendor ID |
15x |
Vendor ID |
Text |
RP_VSTATE |
Vendor State |
20x |
Vendor State: |
Text |
RP_VZIP |
Vendor Zip |
15x |
Vendor Zip Code: |
Text |
RP_WADDR1 |
Warehouse Address |
75x |
Warehouse Address Line 1: |
Text |
RP_WADDR2 |
Warehouse Address 2 |
75x |
Warehouse Address Line 2: |
Text |
RP_WCITY |
Warehouse City |
25x |
Warehouse City: |
Text |
RP_WDESC |
Warehouse Desc. |
50x |
Warehouse Description |
Text |
RP_WNUMBER |
Warehouse ID |
20x |
Warehouse ID |
Text |
RP_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
RP_WSTATE |
Warehouse State |
2x |
Warehouse State: |
Text |
RP_WZIP |
Warehouse Zip |
15x |
Warehouse Zip Code: |
Text |